ensure query is complete

[JT]

I'm running queries in my code. Is there some command or code to insert
after kicking off the query to ensure they query completes before the next
line of code is executed? I have used a "DoEvents" in Excel and was
wondering if there is something similar in Access. Thanks for the
help............

 

[Marshall Barton]

I'm running queries in my code. Is there some command or code to insert
after kicking off the query to ensure they query completes before the next
line of code is executed? I have used a "DoEvents" in Excel and was
wondering if there is something similar in Access. Thanks for the
help............

What kind of query?

What areyou doing with the result of the query.

An action query can be run synchronously by using the
Execute method.

If you are opening a recordset on a Select query, then
either you don't need it to complete or you need to use the
MoveLast method.

If you are opening a query is sheet view, then it doesn't
matter. Access manages the query's records as the user
interacts with the display.