Home  |  About  |   Search   

What's New
Table Of Contents
Credits
Netiquette
10 Commandments 
Bugs
Tables
Queries
Forms
Reports
Modules
APIs
Strings
Date/Time
General
Downloads
Resources
Search
Feedback
mvps.org

RunCommand Constants

Terms of Use


 

Forms: Suspend code until a popup form is closed

Author(s)
Dev Ashish

(Q)    From a form, I'm opening another form to get some infomation from users. Then after closing this popup form, I want to resume my code execution from Form1 normally. However, Access doesn't wait for the second form to close and instead continues executing code. How do I make Access wait till the second form is closed?

(A)    Open the second form modally. For example,

    Docmd.OpenForm "SomeForm", , , , ,acDialog

1998-2009, Dev Ashish & Arvin Meyer, All rights reserved. Optimized for Microsoft Internet Explorer