S
Salmander
I have a marco which runs two make table queries. Query 1 performs
calculations on Table 1 and creates/saves Table 2. Query 2 converts codes
into descriptions and creates/saves as Table 1.
This macro works fine until I tie it to an "on click" procedure in a form.
When the macro is run from the form, when it tries to create/save as Table 1,
I ge the error message "The database engine could not lock table Table 1
because it is already in use by another person or process. (Error 3211)".
I have included a setp before Query 2 to close the form and make certain
Table 1 is closed as well.
Why would the macro work on its own (even when the form is open), and not
work on an event in a form?
calculations on Table 1 and creates/saves Table 2. Query 2 converts codes
into descriptions and creates/saves as Table 1.
This macro works fine until I tie it to an "on click" procedure in a form.
When the macro is run from the form, when it tries to create/save as Table 1,
I ge the error message "The database engine could not lock table Table 1
because it is already in use by another person or process. (Error 3211)".
I have included a setp before Query 2 to close the form and make certain
Table 1 is closed as well.
Why would the macro work on its own (even when the form is open), and not
work on an event in a form?