Fix Microsoft Access Combo Box On Not In List Event Error
Question details
The user is encountering an error where the 'On Not In List' event for a combo box is reported as unsupported, preventing the VBA event procedure from opening.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Attempting to trigger or edit a combo box event on a previously working Microsoft Access form.
- Observed behavior
- Access throws an error stating the event is unsupported and blocks access to the associated VBA event procedure code.
Ensure you create a safe copy of your current front-end database file before attempting any repair operations to prevent further data loss.
Import the Form from a Working Backup
Since the error often points to specific form corruption, restoring the affected form from a known-good backup is the most reliable fix.
Form corruption in Access can cause standard properties and events to suddenly become unrecognized. Pulling a clean version of the form from a backup bypasses the need to rebuild the VBA code from scratch.
Launch Microsoft Access and open the current front-end database file where you want to place the working form.
Navigate to the 'External Data' tab on the ribbon, click on 'New Data Source', select 'From Database', and then choose 'Access'.
Browse for your recent working backup database, select 'Import tables, queries, forms, reports, macros, and modules into the current database', and click OK.
In the Import Objects dialog, go to the 'Forms' tab, select the working version of the corrupted form, and complete the import. Delete the old corrupt form and rename the imported one to match the original name.
Use the Compact and Repair Tool
Access has a built-in utility to fix minor database corruption issues that might be causing the combo box event failure.
Check for Missing VBA References
Broken or missing VBA library references can cause native Access events to be falsely recognized as 'unsupported'.
Looking for a Lightweight Alternative for Your Office Tasks?
While WPS Office does not include a database management tool like Access, it is a highly efficient, free alternative for handling your Word documents, Excel spreadsheets, and PowerPoint presentations. If you want to avoid heavy software issues in daily office tasks, consider WPS Office.
Frequently Asked Questions
What causes a Microsoft Access form to become corrupt?
Form corruption often happens due to network interruptions while saving, improper system shutdowns, bloated database sizes, or repetitive modifying of VBA code in Design View without periodically compiling the code and compacting the database.
Does the 'On Not In List' event work for all combo boxes?
Yes, it is a standard built-in event for Access combo boxes, provided the 'Limit To List' property is set to 'Yes'. If Access suddenly reports it as unsupported, it usually indicates a structural error, a missing VBA reference, or corruption isolated to that specific control or form.
How do I recreate a corrupt combo box without losing data?
Open your form in Design View, take note of the existing combo box properties, and delete the control. Add a new combo box from the Form Design toolbox, bind it to the same underlying field in the 'Control Source' property, re-apply your 'Row Source' query, and rewrite or reconnect the VBA events.
