Pausing Execution

[grep]

I'd like to have a button on one form open another form, and wait until
that second form is closed before continuing its own execution. How
might I do that?

grep

 

[Sandra Daigle]

Use the acDialog option of the Windowmode parameter of the openform
command. This will suspend the code until the opened form is either
*hidden* or *closed*.

docmd.OpenForm "frmMyForm",,,,,acDialog

 

[grep]

Perfect, Sandra (and fast!!). Thanks so much.

grep

 

[Ron Weiner]

Grep

Open the form Modaly as in:

DoCmd.OpenForm "YourFormName",,,,,acDialog

The code in the caller will pause till the form it opened has been closed

Ron W