Hide form

[DBFIN]

My primary form opens a secondary form via an onload event. Is there a way for the secondary form to be open, but hidden so that a user can not see the form at all ? In MS Access 2003, all secondary forms were hidden, but in MS Access 2010, all forms are shown as a separate tabs. How can I hide a secondary tab.

 

[Beetle]

Use the acHidden Window Mode argument of the OpenForm method;

DoCmd.OpenForm "Form2", , , , , acHidden

You just need to make sure you also have appropriate code somewhere to close the form and/or make it visible when needed.

 

[DBFIN]

Is there a standard MS Access function that I can use in the expression or macro builder that does not require inputing customized code ?

 

[Beetle]

If you're using a macro then in the arguments section for the Open Form action you can select Hidden in the Window Mode drop down.