Suspend code execution until another form is closed

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SAC - 24 Oct 2007 14:23 GMT

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.

Reply to this Message

Dale Fye - 24 Oct 2007 14:56 GMT

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

Signature

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

Email address is not valid.
Please reply to newsgroup only.

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

Reply to this Message

SAC - 24 Oct 2007 17:54 GMT

Excellent! Thanks.

> You need to open the form as modal. The easiest way to do this is to set
> the
[quoted text clipped - 14 lines]
>>
>> Thanks for your help.

Reply to this Message