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
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
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.
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?
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.