Fix Microsoft Access Subform Requery Not Working for Combo Box
Question details
A combo box fails to requery or update its options when the form is displayed as a subform, despite working correctly when opened as a standalone form.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Filtering or dynamically updating a dependent combo box located inside a subform based on another control's value.
- Observed behavior
- The requery operation fails to trigger correctly, leaving the combo box with unfiltered or outdated data due to an invalid control reference.
Verify the exact names of your Main Form, the Subform Control container (which may differ from the source object name), and the target Combo Box before modifying your code or query criteria.
Use the Full Subform Control Reference Syntax
Update the control reference in your query criteria or VBA code to properly target the subform container on the main form.
When a form is used as a subform, it loses its standalone identity in the Microsoft Access object hierarchy. To reference a control within it, you must route the reference through the main form and the specific subform control container.
Open the Main Form in Design View. Click once on the edge of the subform to select the container control. Open the Property Sheet and note the 'Name' property under the Other tab.
If your combo box relies on a query for its Row Source, open the query and update the criteria referencing the driving combo box to the full path: Forms!MainFormName!SubformControlName.Form!DrivingComboBoxName.
Open the Property Sheet for the driving combo box, click the Event tab, and select [Event Procedure] for the On Change or After Update event. Click the ellipsis (...) and add the requery command: Me!SubformControlName.Form!DependentComboBoxName.Requery.
Looking for a Lightweight Alternative for Daily Office Tasks?
While Microsoft Access handles complex database management, most of your daily spreadsheet, document, and presentation tasks can be done more efficiently. WPS Office offers a free, lightweight alternative that is highly compatible with standard Microsoft Office files, giving you a seamless experience without the heavy system requirements.
- 1. Download WPS Office: Visit the official WPS Office website and click the free download button for your operating system.
- 2. Install the Software: Run the installer and follow the quick on-screen instructions to set up the software.
- 3. Open Your Files: Launch WPS Office and instantly open your existing Excel, Word, or PowerPoint files without losing formatting.
Frequently Asked Questions
Why does my VBA requery code work in a standalone form but fail in a subform?
In a standalone form, controls can be referenced directly using the 'Me' keyword or just the form's name. When embedded as a subform, the form acts as a property of a control on the parent form, meaning you must specify the fully qualified path (Forms!MainForm!SubformControl.Form!ControlName) to reach it.
How do I find the correct subform control name in Access?
Open the main form in Design View and click on the border of the subform area. Check the Property Sheet for the 'Name' property. This is the container name, which is often different from the name of the form object displayed inside it.
Can I use macros to requery a subform combo box instead of VBA?
Yes, you can use the Requery macro action. However, you must specify the exact control name using the full subform path syntax (Forms!MainForm!SubformControl.Form!ControlName) in the Control Name argument of the macro for it to successfully locate the subform's combo box.
