Unanswered: Show a report up front after Macro has finished
I have set up a macro which displays a please wait form, because I have a query that takes a while to run!! Once it has finished running the please wait form closes and the related report opens in print preview mode.
The only problem is that when it opens it opens behind the Main menu form which the button is on that runs the macro!! is their any way to pre-set the screen order, like send to front with an image??
If I close the main menu form on opening of the report, that would solve it but, when you close the report using the cross at the top the main menu form would not be there!!