open new form in code and wait

[cliff7376]

I have a customization i need to make in a system we have. I have a new form that I need to open in code from the form that is active. The problem that i have is that i need the previous form to wait until the new form closes to finish executing it's code(put it in a loop or something?). Does anyone have an idea on how to accomplish this?

 

[Mile-O]

When you open the pop-up/second form ensure that you open it as a dialog form - that way the code waits until the form is closed before it continues..

DoCmd.OpenForm "frmYourForm", acNormal, , , , acDialog

 

[cliff7376]

Thank you very much. Great help