platypus71
Technical User
I have a macro that is causing me some headaches.
The macro is accessed by pressing a button on a form. The form contains a subform which has data from Table1. At the bottom of the form are some data fields with data from Table2.
Here is the macro:
OpenQuery Query1 (updates Table1)
OpenQuery Query2 (updates Table2)
RunMacro Macro2 (this macro recalculates data based on the new contents of Table1, then updates some fields in Table2)
The error I get is "The data has changed. Another user edited this record and saved the changes before you attempted to save your changes. Re-edit the record."
The end result is Query1 and Query2 worked. Macro2 didn't happen.
Any suggestions on how to make this work?
Thanks.
The macro is accessed by pressing a button on a form. The form contains a subform which has data from Table1. At the bottom of the form are some data fields with data from Table2.
Here is the macro:
OpenQuery Query1 (updates Table1)
OpenQuery Query2 (updates Table2)
RunMacro Macro2 (this macro recalculates data based on the new contents of Table1, then updates some fields in Table2)
The error I get is "The data has changed. Another user edited this record and saved the changes before you attempted to save your changes. Re-edit the record."
The end result is Query1 and Query2 worked. Macro2 didn't happen.
Any suggestions on how to make this work?
Thanks.
