MS Access 2003 - Another user edited this record and saved the changes before you attempted to save your changes
Posted on 2011-10-05
I have a a rather compilcated form with a number of child forms. Changes to the parent record can change associated records in child tables and all changes or additions to child records change values in the parent record.
Not always, but frequently, after making changes to a child record and upon attempting to make changes to the parent record, I get the following error message:
The data has been changed. Another user edited this record and saved the changes before you attempted to save your changes. Re-edit the record.
I know that this relates to unsaved records and I have added me.dirty = false to a number of locations in my VB code including the lost and got focus events for the main form and subforms. However, it hasn't corrected the problem.