Is there a way to know what Queries in a Macro are running?

[BlackOnBlack]

I've got a Macro that runs well over 100 queries as well as sub-macros. I'd like to know what query the Macro is running. My best solution so far was to create a bunch of forms that open and close with the name of each query, but that's kind of sloppy. I don't think I can use the msgbox because it prompts me to press 'OK' to continue. Any thoughts?

 

[ghudson]

Add a label to your form. Update the caption of the label with the name of the query you are running. Or use [update] the status bar at the bottom left of the Access application. This would probably be easier to do with VBA.

 

[BlackOnBlack]

This is a good idea...thanks!