Suspend code execution until another form is closed

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

 

[Dale Fye]

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

 

[SAC]

Excellent! Thanks.

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.