I have a single form. When an item is selected by a combo box on the form, its id is inserted into a field on the main form for use in calculations later.
To make changes in the combo box source table, the user can click a button that opens a popup form that contains a list of Sail types and numerical factors. Fields are locked.
After the user enters a password, the subform unlocks the factor field to permit changes.
My problem is that when I close the popup form after a change, I get the message "Could not update, locked by another session on this machine".
There is no other "session". I have two similar setups for other Sail types and neither gives me this problem.. I even recreated the pop up source table and the popup form and same problem. Must be related to the main form, but how?
One thing I tried, from another help site was to modify code opening the sub from the main form to show "If Me.Dirty Then Me.Dirty = False." Didn't help. I couldn't find anything else that applied to this situation.
I am using A2007. All tables are linked to a separate file holding only tables. No one else is using tables when error message occurs.
Any help much much appreciated.