Macro Sequence

[Kinger43]

When a macro runs, does it wait for the previous step to finish before beginning the next? In one macro I have it runs a query that takes a little time to run due to the large number of records. I want to close the database when the macro is finished running (this is an automated task that runs when I am not here) but I don't want to add this step if it is going to try to close in the middle of running the query.

 

[hawkpig]

Macros do wait for the next step to finish but if it calls a batch job or something outside of access it will move immediately to the next instruction in the macro even if the batch job has not finished. So assuming all your macro instructions relate to data within the database then it will only close when everything else is done.

Hope this helps