• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 182
  • Last Modified:

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?
0
dsoderstrom
Asked:
dsoderstrom
1 Solution
 
peter57rCommented:
Use the acDialog option in the DoCmd.Openform statement.
0
 
Luke ChungPresidentCommented:
You can also set the modal proerty of the form to Yes.
0
 
dsoderstromAuthor Commented:
That was the solution I needed.  Thanks for the help
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now