Return to code after opening a from

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have Form-A with CmdButton-B to execute code. In that code I need to Open
Form-X on line 12 of the code. Is there a way to return to Line 13 of the
code after closing Form-X?

steve
 
Open the form in Dialog mode like this:

DoCmd.OpenForm "FormX", windowmode:=acDialog
Msgbox "Back to business!"

When it's opened in dialog mode, the code will pause until the form is
closed and then resume with the next line.

Barry
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using a form for more than one use 1
Excel VBA - Problem with Closing Print Preview 0
Code executes but control doesn't 7
How to pass, via VBA, a value like [parameter] of a query? 1
Access crashing and ?fix? 6
need function to notice cmdbutton Name 2
Form will not update calculations 1
Need focus on query first, then on Form when query is closed 5

Back
Top