C
Chris
I have 3 subforms with each having a table as data source on one main form.
I am trying to run a delete then append query on each of those 3 tables
BEFORE each of the 3 subforms load, to make sure the records are updated on
any additions deletions(from other areas of the database.). i keep getting
an error on the second form saying could not lock the table because it is
already open by another user. The tables are not open anywhere else. I
assume it is trying to load the table before the query's run and the query's
are causing the error. I have put the DoCmd of the open querys on the on
open event of each of the subforms, i have tried putting all the commands for
all three on the on open event of the main form, and keep getting the error.
I am trying to run the commands before the tables are opened by the forms,
but am not having any luck. i do need the queries to run before they are
opened. Any ideas would be great, thanks.
I am trying to run a delete then append query on each of those 3 tables
BEFORE each of the 3 subforms load, to make sure the records are updated on
any additions deletions(from other areas of the database.). i keep getting
an error on the second form saying could not lock the table because it is
already open by another user. The tables are not open anywhere else. I
assume it is trying to load the table before the query's run and the query's
are causing the error. I have put the DoCmd of the open querys on the on
open event of each of the subforms, i have tried putting all the commands for
all three on the on open event of the main form, and keep getting the error.
I am trying to run the commands before the tables are opened by the forms,
but am not having any luck. i do need the queries to run before they are
opened. Any ideas would be great, thanks.