Pausing Execution

  • Thread starter Thread starter grep
  • Start date Start date
G

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
 
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

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
 
Back
Top