Using Multiple Forms at the Same Time in Access

[JM11]

Hello,
I am developing an access application and I need to let the user alternate between several forms without closing any of them;
Thus my question is: Can we minimize a form and use another one while keeping the first one open?

Thank you for your help!

[zmbd]

Simple answer is yes and no...

YES: Since ACC2010 the default view is a tabbed GUI where once opened the access object (DAO) stays opened and available for reference. Download the Northwinds Trader template for an example. You can switch this to the older ACC2003/2000 style from the options.

NO: HOWEVER, there is the new Navigation Form Control starting in ACC2010 (not to be confused with the access objects navigation pane where one can manage the DAOs), the subforms there do not stay open for reference. They reopen fresh when ever you switch "tabs" in the navigation control. Thus, you have to pass the values using the WHERE conditional, Tempvars, or other controls on the parent form before the subform closes.