Need help in form calling properties

[ashishprem]

Hi,
I need some help in calling form..
A function is being executed in a form1. In this function a call is there to open form2. The form2 opens. No problem in this. But when form2 opens it resumes the execution of the remaining part of the function in Part1.
What I want is once form2 opens it should pause the exeution of form1 and once form2 is closed then resume the execution of form1. Any suggestion to implement this.

Ashish

 

[missinglinq]

Open the second form in Dialog mode, like this:

DoCmd.OpenForm "YourSecondFormName" , , , , , acDialog

Execution of the first form's code will stop until the second form is closed.

 

[ashishprem]

it worked dude..
Thanks a lot.

 

[missinglinq]

Glad you got it working!