Opening a form from VBA code and pausing

When clicking a command button on Form1 I am excuting vba code which opens Form2.  I would like to halt the excution of the lines of code following the OpenForm command until an action is taken on Form2 and it is closed.  What is the best way to do this?
dsoderstromAsked:
Who is Participating?
 
Luke ChungConnect With a Mentor PresidentCommented:
You can also set the modal proerty of the form to Yes.
0
 
peter57rCommented:
Use the acDialog option in the DoCmd.Openform statement.
0
 
dsoderstromAuthor Commented:
That was the solution I needed.  Thanks for the help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.