Alan T said:
How do I open a form in Modal mode?
If you set the Modal property of the form to Yes then it will be "modal" when
you open it. That is, no other object will be able to receive focus until you
close or hide that form.
If what you need though is for your calling code to pause until the form is
hidden or closed then you need to use the acDialog argument of the OpenForm
method.
DoCmd.OpenForm "FormName",,,,,acDialog
