I have a subform in a parent form. In this parent form, I wish to be able to enter data. However, when I set the 'Allow Additions' property of my subform to 'Yes', it immediately changes back to 'No'. How can I fix this?
Novice
Windows 10 
Access 2016
I have a subform in a parent form. In this parent form, I wish to be able to enter data. However, when I set the 'Allow Additions' property of my subform to 'Yes', it immediately changes back to 'No'. How can I fix this?
VIP
Windows Vista Access 2010 32bit
is the subform set to a table?
does the subform have the master key in the form?
is the subform set to dynaset?
does the relationship allow data entry? (some dont)
VIP
Windows 7 64bit Access 2007
The Access Gnomes consider doing anything to a Subform (Adding/Deleting/Editing Records) to be 'editing' it, and I believe you'll get this behavior if AllowEdits on the Main Form is set to No...the Subform is, after all, a Control on the Main Form. Is that the situation, here?
Linq ;0)>
Last edited by Missinglinq; 08-13-2016 at 12:32 PM.
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007
Novice
Windows 10 Access 2016
oh my god you're amazing. thank you so much! i changed the main form the allow edits and my subform now works! THANKS x
VIP
Windows 7 64bit Access 2007
You just have to understand how the Access Gnomes think!
Glad we could help!
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007
acFormEdit is allowing form additions
Posting Permissions
Reply With Quote