Log in

View Full Version : Problem Editing A Record



ukdane
01-14-2010, 01:33 AM
I have a subform on a form.
I can edit the details on the form, but I am unable to change details on the sub form.
What could be causing this problem, stoping me from editing records?

Edit: Thanks

OBP
01-14-2010, 04:45 AM
Is the Subform's record source an editable Recordset?
Has the Subform's Properties been set ot allow edits = NO?

ukdane
01-14-2010, 04:49 AM
Is the Subform's record source an editable Recordset?

Yes

Has the Subform's Properties been set to allow edits = NO? No, it's set to = YES

OBP
01-14-2010, 07:50 AM
Can you post the databasr?

ukdane
01-15-2010, 12:45 AM
Hi OBP,

Unfortunately I can't post it, as it now contains work sensitive data.

Could it have anything to do with the fact that the main and sub form are copies of existing forms and subforms, pointing to the same table as the originals?

I know in theory it's not necessary to create duplicate forms, but for some reason, after I set the original forms to only show empty records when accessed from one menu, when I then try to access from another menu, I couldn't get it to show existing records- when I created copies of the forms, it worked- however, I can't adjust/edit the records.

OBP
01-15-2010, 07:10 AM
You shouldn't need two sets of forms, normally the type of Form View can be set from the menu using VBA.
Can't you take a copy of the database and delete all of it's records and just create a dummy record for each table?