Others

How to Hide an Access Dashboard Without Blocking Data Entry

Ayan Masood Oct 10, 2026 869 views

Question details

The user wants to temporarily hide a Microsoft Access dashboard while users enter data into a related contact form or subform, and then restore the dashboard's visibility once the data entry is complete.

How to Hide an Access Dashboard Without Blocking Data Entry

Product: Microsoft Access
Device & OS: not provided
Scenario: Managing form navigation and interface flow in an Access database application.
Observed behavior: The dashboard currently remains visible or interferes with the data entry process, requiring a way to temporarily hide it and show it later without fully closing the form.

Before you start

Before modifying your database forms, ensure you have a backup copy of your Access database file (.accdb) to prevent accidental data or code loss during VBA edits.

Solution 1Recommended

Toggle Form Visibility Using VBA

Use simple VBA code to hide the dashboard when opening the data entry form, and unhide it when closing the data entry form.

Instead of completely closing the dashboard, modifying its 'Visible' property allows you to keep the form loaded in memory. This ensures any temporary variables, filters, or unbound field selections are preserved while users interact with the child form.

Hide the dashboard upon opening the destination form

Open your dashboard form in Design View. In the On Click event of the button used to open the data entry form, add your open command followed by the hide command: DoCmd.OpenForm "frmContacts" followed by Me.Visible = False.

Restore the dashboard upon closing the destination form

Open your destination data entry form (e.g., frmContacts) in Design View. Navigate to the form's Property Sheet, select the Event tab, and click the builder button (...) next to 'On Close'. Add the code: Forms("frmDashboardName").Visible = True.

Save and test the navigation

Save both forms, switch to Form View, and click the navigation button. The dashboard should disappear while the contact form opens, and reappear seamlessly when the contact form is closed.

Preserved State: Because the dashboard is only hidden and not closed, it will not need to reload its underlying queries when it reappears, making the navigation feel instant.

Solution 2

Use an Unbound Combo Box for Filtered Navigation

Navigate to specific client records directly from the dashboard using an unbound combo box instead of relying on parameter queries.

Free Microsoft Office alternative

Looking for a Lightweight Microsoft Office Alternative?

While Microsoft Access is a specialized tool for relational databases, many everyday data tracking, list management, and data entry tasks can be handled efficiently with WPS Spreadsheet. WPS Office is a free, lightweight, and highly compatible alternative for your document, spreadsheet, and presentation needs.

1. Download the installer: Visit the official WPS Office website and click the free download button to get the latest version.
2. Install WPS Office: Run the downloaded setup file and follow the on-screen instructions to install the suite on your computer.
3. Start managing your data: Open WPS Spreadsheet to create intuitive data entry forms, trackers, and dashboards without complex VBA coding.

Fully compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) file formats.Manage simple data entry, lists, and dashboards using advanced Spreadsheet functions.Free to use with a familiar, tabbed interface for a seamless transition.Lightweight installation that runs smoothly on older or slower devices.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Access dashboard block data entry in the first place?

This usually happens if the dashboard or the subsequent form is opened in 'Dialog' mode (WindowMode = acDialog). Dialog mode halts code execution and blocks interaction with all other forms until the dialog form is closed or hidden.

Can I just close the dashboard instead of hiding it?

Yes, you can use 'DoCmd.Close acForm, "DashboardName"' to close it completely. However, hiding it ('Me.Visible = False') is often preferred because it preserves any temporary variables, unbound field selections, or form states.

What happens if I rename my dashboard form later?

If you rename your dashboard form, you must manually update the VBA code in the data entry form's 'On Close' event (e.g., updating it to Forms("NewDashboardName").Visible = True). Otherwise, Access will throw an error stating it cannot find the referenced form.

Office Quick Solutions