One Form to Run Another

  • Thread starter Thread starter Ross
  • Start date Start date
R

Ross

How do I fire a procedure in a 2nd form from a first
Form , a popup? ie run a subroutine from information
entered into a popup form.

I want to close the popup after the user entered data is
finished and continue running in the Popup.

Can you interupt the form 2 code to wait for the popup
information?

Thanks

Ross
 
Try using the acDialog option for WindowMode on the Docmd.Openform:

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

This will pause the code until the opened form ("frmMyForm") is closed
or is hidden. If I need to get any information from the dialog form I
will usually put an OK command button on the popup form that sets the
visible property to false. Then in the code that opened the form (ie
following the docmd.openform) I can check values of controls on the now
hidden dialog form, then close it.
 
Back
Top