PRA: Menu Bar Does Not Change When Closing Modal Pop-Up Form

Article ID: Q117541
Creation Date: 30-JUN-1994
Revision Date: 19-SEP-1996

The information in this article applies to:

Microsoft Access versions 1.0, 1.1, 2.0

SYMPTOMS

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

When you open a modal pop-up form by choosing a command button on another form, the Microsoft Access menu bar changes to show only two menus, File and Help. When you close the modal pop-up form, the menu bar does not change back to the standard Microsoft Access menu bar.

RESOLUTION

There are two ways to work around this problem:

In the macro that opens the modal pop-up form, reverse the order of your macro actions. Instead of opening the modal pop-up form and then closing the form that starts the macro, first close the form from which the modal pop-up form is opened, and then open the modal pop-up form.
After you close both forms, select an object in the Database window to restore the menu bar.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access versions 1.0, 1.1, and 2.0. This problem no longer occurs in Microsoft Access for Windows 95 version 7.0.

MORE INFORMATION

Steps to Reproduce Problem

Create a new form with one command button. Save the form as Form1 and then close it.

Create another new form with a label set to "Look at the menu bar now." Set the form's Model and PopUp properties to Yes. Save the form as Form2 and then close it.

Open Form1 in Design view. Set the command button's OnClick property (or OnPush property, in version 1.x) to a macro called MacroX.

Create a new macro with the following settings:

      Macro Name   Actions
      ---------------------
      MacroX       OpenForm
                   Close

      MacroX Actions
      ---------------------
      OpenForm
         Form Name: Form2
      Close
         Object Type: Form
         Object Name: Form1

Save the macro as MacroX and then close it.

View Form1 in Form view and then click the command button. Note that when Form2 opens, the Microsoft Access menu bar changes to show only two menus, File and Help.
Close Form2. Note that the standard Microsoft Access menu bar does not return.

REFERENCES

For more information about dialog boxes, search for "PopUp," and then "Creating Pop-Up Forms and Dialog Boxes" using the Microsoft Access Help menu.

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.