Others

How to Troubleshoot an Access List Box Click Event Not Working

Steve K Oct 1, 2026 869 views

Question details

The user needs to fix an Access list box on a main form that does not respond to click events, despite the same setup working on a different form.

How to Troubleshoot an Access List Box Click Event Not Working

Product: Microsoft Access
Device & OS: not provided
Scenario: Building or editing a Microsoft Access database form with VBA event procedures.
Observed behavior: The list box click event fails to trigger on the main form, ignoring user clicks.

Before you start

Before troubleshooting, ensure your Access database is saved and compile your VBA project to check for any underlying code errors.

Solution 1Recommended

Verify List Box Properties and VBA Event Links

Ensure the list box is enabled, unlocked, and correctly linked to the VBA event procedure.

The most common reason a list box fails to trigger an event is a disconnect between the form control and the VBA backend, or restricted control properties.

Open Design View

Right-click your main form in the navigation pane and select 'Design View'.

Check Data Properties

Select the problematic list box and press F4 to open the Property Sheet. Under the Data tab, ensure 'Enabled' is set to Yes and 'Locked' is set to No.

Verify Event Procedure

Switch to the Event tab in the Property Sheet. Find the 'On Click' property and ensure it is set exactly to '[Event Procedure]'.

Confirm Procedure Name

Click the ellipsis (...) next to the On Click property to open the VBA editor. Verify that the procedure name matches the control name exactly (e.g., ListBoxName_Click).

Verify List Box Properties and VBA Event Links

Tip: If the VBA procedure was renamed or the control was recreated, Access might lose the linkage. Clicking the ellipsis forces Access to re-link or create the correct sub procedure.

Solution 2

Check for Overlapping Controls or Form Layout Issues

Sometimes an invisible or transparent control overlays the list box, intercepting the click events.

Solution 3

Recreate the List Box Control

If the control itself is corrupted, replacing it with a new one can restore normal functionality.

Free Microsoft Office alternative

Looking for a Lightweight Office Suite?

While Microsoft Access handles complex database management, for your everyday document, spreadsheet, and presentation needs, WPS Office provides a free, highly compatible, and lightweight alternative to Microsoft Office.

1. Download the Installer: Visit the official WPS Office website and click the free download button.
2. Install WPS Office: Run the downloaded installer file and follow the on-screen instructions to complete the setup.
3. Open and Edit: Launch WPS Office and instantly open your existing Word, Excel, or PowerPoint files without losing formatting.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats.Free and lightweight, taking up significantly less system resources.Familiar tabbed user interface for seamless migration and daily use.Built-in PDF editing, conversion, and signature tools.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my VBA code run on one Access form but not another?

This usually happens due to mismatched control names, disconnected event properties (such as a missing '[Event Procedure]' tag in the property sheet), or form-level properties like 'Allow Edits' being set to No.

Can a disabled list box still trigger a click event?

No. If a list box's 'Enabled' property is set to No in the Data tab, it cannot receive focus or respond to user interactions, meaning the On Click event will never fire.

How do I ensure my VBA event name matches the list box?

In the VBA editor, the subroutine must be exactly named `YourListBoxName_Click()`. If you rename the list box on the form design view, you must also manually update the corresponding VBA event name to match.

Office Quick Solutions