Others

Keep a Microsoft Access Main Menu Form Open

Amos GikundaAmos Gikunda Nov 14, 2026 868 views

Question details

Keep a main menu form available while users work with other database objects in Microsoft Access.

Keep a Microsoft Access Main Menu Form Open
Product
Microsoft Access
Device & OS
not provided
Scenario
Users navigate from a main menu form to other forms and reports and need to return to the menu.
Observed behavior
Access does not automatically reopen the navigation form after other database objects are closed.
Before you start

Identify the form you want to use as the main menu and check its name in the Navigation Pane. Make sure you can open the database and edit its forms and startup options.

Solution 1Recommended

Open the main menu at startup and leave it open

Use this approach to keep the menu available throughout a database session without reopening it after every object closes.

1
Set the startup form

In Access, select File > Options > Current Database. Under Application Options, choose your main menu form in the Display Form list, then select OK.

2
Restart the database

Close and reopen the database to apply the startup setting. Confirm that the main menu form opens.

3
Check the form properties

Open the main menu in Design View and use the Property Sheet to check its Modal property. Set Modal to No if it prevents users from working with other objects; also avoid opening the menu in Dialog mode.

4
Keep the menu open during navigation

Check the menu buttons and their macros or VBA code. Open the target forms and reports without closing the main menu form, then close the target objects when finished.

Open the main menu at startup and leave it open
The menu may be behind another object: In a tabbed database, an open form may not be the active tab. Select the main menu tab to return to it.
Free Microsoft Office alternative

Use WPS Office for Documents and Spreadsheets Alongside Access

WPS Office is a free, lightweight alternative for everyday office documents, with a familiar interface and Microsoft Office format compatibility to help you move existing files. It does not replace Microsoft Access or fix Access form settings.

Work with documents and spreadsheets used alongside an Access databaseOpen and edit common Microsoft Office formats, including DOCX, XLSX, and PPTXUse a familiar interface for everyday office tasksMove existing Office files into a free, lightweight suite
QA img-9

Frequently Asked Questions

How do I make my Access menu form open automatically?

Go to File > Options > Current Database, select the form under Display Form, and click OK. Close and reopen the database for the setting to take effect.

Why can't I work with other forms while my menu is open?

The menu may be modal or opened in Dialog mode. In Design View, check the form's Modal property in the Property Sheet and set it to No if it blocks the workflow. Also check how the menu is opened.

Will Access automatically reopen the menu after I close another form?

Not necessarily. The simplest approach is to leave the menu open while other forms and reports are in use. Alternatively, you can add code to an object's Close event to reopen the menu when appropriate.

What if the menu is open but I can't see it?

If the database uses tabbed documents, the menu may be on another tab. Select its tab, and check your navigation buttons for any action that closes the menu.