PRB: Hidden Pop-Up Forms Not Listed in Show Dialog Box

Article ID: Q109359
Creation Date: 02-JAN-1994
Revision Date: 19-SEP-1996

The information in this article applies to:

Microsoft Access versions 1.0, 1.1, 2.0, 7.0

SYMPTOMS

Moderate: Requires basic macro, coding, and interoperability skills.

When you hide a pop-up form using the OpenForm action with a hidden flag, the form does not appear in the Show dialog box object list.

CAUSE

Only multiple document interface (MDI) windows appear in the Show dialog box object list, and pop-up windows are not MDI windows.

MORE INFORMATION

Steps to Reproduce Behavior

Start Microsoft Access and either create a new database or open one of your choosing.

Create the following function:

      Function HideForm(FormName$)
         DoCmd.OpenForm FormName$,0,,,1,1 ' In version 7.0 only.
         DoCmd OpenForm FormName$,0,,,1,1 ' In versions 1.x and 2.0 only.
         ' Opens form as hidden.
      End Function

Create a new form and set its PopUp property to Yes.
Add a button control to the form and set the button's OnClick property to:
```
      =HideForm("<your form name>")
```
Substitute the name of your form for <your form name> in the example above.
NOTE: In Microsoft Access version 1.x, the OnClick property is called the OnPush property.
Open the form in Form view and click the command button.
Click the Window menu. Note that although the form is hidden, the Show command is unavailable. If you have previously hidden windows, the pop-up window does not appear in the Show dialog box.

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.