I get the "this record has been changed by another user since you started editing it" message when I first make an edit in a subform then click on anything in the parent area. It won't give me the option to save, just "copy to clipboard" or "drop."
Both the parent and the subform use the same table in their RecordSource. The only difference being that, the subform has a RecordSource that joins a 2nd table in its query.
When I edit (within the subform) a textbox that is bound to the 2nd table, I don't get any locked out message. But when I edit a textbox bound to the first table (the table which is also used by the parent), then I get the locked out message.
The parent does not actually update any data. It merely reads a record.
How can I make it save, without that lockout message?
Both the parent and the subform use the same table in their RecordSource. The only difference being that, the subform has a RecordSource that joins a 2nd table in its query.
When I edit (within the subform) a textbox that is bound to the 2nd table, I don't get any locked out message. But when I edit a textbox bound to the first table (the table which is also used by the parent), then I get the locked out message.
The parent does not actually update any data. It merely reads a record.
How can I make it save, without that lockout message?
Comment