How to Fix Access Cascading Combo Boxes in a Continuous Form
Question details
The user needs to make a dependent Subsector combo box display and filter correctly for each record in an Access continuous form.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Setting up cascading dropdowns (Sector and Subsector) in a continuous form environment.
- Observed behavior
- The Subsector combo box incorrectly uses the Sector value from the first row for all records, instead of dynamically filtering based on the current active record's Sector.
Before altering your form's events and control properties, ensure your database is backed up and that the relationship between your primary and dependent tables is properly established.
Update Requery Events in Form Design
Trigger a requery of the dependent combo box whenever the primary category changes or when navigating to a different record.
In a continuous form, Microsoft Access reuses the same combo box control for every row. To ensure the dependent list filters correctly based on the active row, you must explicitly tell Access to requery the control.
Open your form in Design View. Select the primary 'Sector' combo box, open the Property Sheet, and navigate to the Event tab. In the 'After Update' property, add the code: Me.[Subsector].Requery
Select the Form itself (using the square in the top-left corner). On the Event tab, find the 'On Current' property and add the exact same code: Me.[Subsector].Requery
Select the 'Subsector' combo box. Under the Data tab, ensure the Row Source query uses criteria linking back to the primary combo box, such as [Forms]![YourFormName]![SectorComboBox].
Implement a Hybrid Text Box Design
Overlay a bound text box over the combo box to reliably display the stored value across all rows without visual glitches.
Manage Data Easily with WPS Office
While Microsoft Access is a dedicated database tool, many data tracking, entry forms, and cascading dropdown tasks can be efficiently handled using WPS Spreadsheet. WPS Office is a free, lightweight suite offering robust compatibility with Microsoft formats.
- 1. Download and install: Visit the official WPS website to download and install the free WPS Office suite.
- 2. Open WPS Spreadsheet: Launch WPS Spreadsheet and open your existing data tracking files.
- 3. Set up data validation: Use the Data Validation feature to easily recreate dependent cascading lists for your records.
Frequently Asked Questions
Why do inactive rows in my Access continuous form go blank when I requery the combo box?
In a continuous form, Access only maintains one instance of the combo box control. When you requery it to match the active row's category, any inactive row whose stored value isn't in that newly queried list will appear blank visually, even though the underlying data in the table remains completely intact.
Can I use continuous forms with cascading combo boxes without VBA?
While you can use Access Macros (using the Requery macro action) to trigger the update on the 'After Update' and 'On Current' events, some form of logic is absolutely required to tell the form when to refresh the dependent dropdown list based on the active row.
How do I base the dependent combo box on the main combo box?
Open the property sheet for the dependent combo box, navigate to the Data tab, and modify the Row Source query. Add criteria under the related foreign key field that points directly to the main combo box on your form, formatted as [Forms]![YourFormName]![MainComboBoxName].
