Pause Code for another form to execute

[AmatuerAtBest]

Is there a way to pause the code so that another form can execute. I am using the code to launch a form, collect data in that form, and then it needs to use that data in the rest of the function. The problem I am running into is that the code does not pause while the other form is open, so the information is not properly received.

I tried to use a msgbox with vbokonly to force a pause, but with this box open, it would not let me work in the new form.

Thanks for any help

 

[Eupher]

Hi, AmatuerAtBest,

Open the 2nd form in dialog mode - that will suspend code execution until the form closes. See the WindowMode argument of the OpenForm method.

HTH,

Ken S.