Suspend code execution until another form is closed

  • Thread starter Thread starter SAC
  • Start date Start date
S

SAC

I'm trying to use the not in list event to open a form, add information in
it, close the form, and then finish the rest of the not in list code, but I
don't know how to stop it after I open the form.

Thanks for your help.
 
You need to open the form as modal. The easiest way to do this is to set the
WindowMode parameter of the docmd.OpenForm method to "acDialog".

That will suspend your code and as soon as that form is closed (or hidden),
the code in your NotInList event will continue to process.

HTH
Dale
 
Excellent! Thanks.
Dale Fye said:
You need to open the form as modal. The easiest way to do this is to set
the
WindowMode parameter of the docmd.OpenForm method to "acDialog".

That will suspend your code and as soon as that form is closed (or
hidden),
the code in your NotInList event will continue to process.

HTH
Dale
--
Don''t forget to rate the post if it was helpful!

Email address is not valid.
Please reply to newsgroup only.
Click to expand...
 
Back
Top