Originally Posted by
zosta
The subforms, when opened as a stand alone forms, work fine and there is no problems wih locking.
I have checked all possible "Allow edits" properties and they are all set to "yes".
Including the AllowEdits Property on the Main Form? Can you Edit Records on the Main Form? If AllowEdits is set to No/False for the Main Form, or if the Main Form is Read-Only, no Subform Records can be added to or edited, because they reside on Subform Controls on the Main Form, and Access considers anything you attempt to do to these Controls as 'editing.'
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007