How do I open a form in Modal mode? 

"Alan T" <alanpltseNOSPAM@yahoo.com.au> wrote in message 
news:e1bXBBAqHHA.4772@TK2MSFTNGP05.phx.gbl...
> 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


-- 
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com