Please Wait Form

[depawl]

I've developed a form that runs via a macro for a long running query that pops up a message:
"Please Wait".
The query involves parameters that the user must input.
What I'd like to accomplish is to not have the pop-up message appear until after the user inputs the parameters.
I think this could somehow be done using the timer function of the form, but as of yet haven't been able to get it to work.
Thanks in advance.

 

[depawl]

Here's the form with an explanation of what I'm doing:
https://support.microsoft.com/en-us/kb/290133

 

[plog]

You should probably create inputs on the form for those parameters. Have them enter the parameters, then click a button to start the macro, then the Please Wait message comes up and needs nothing from them until its complete.

 

[depawl]

Thanks plog. Just got back to this after doing some other stuff. Tried your suggestion and it works fine.