Others

How to Save Cascading Combo Box Values in Microsoft Access

Aamir Naveed Akram Oct 12, 2026 871 views

Question details

The user needs a method to permanently save the data selected from dependent or cascading combo boxes into their underlying database records.

How to Save Cascading Combo Box Values in Microsoft Access Forms

Product: Microsoft Access
Device & OS: not provided
Scenario: Designing a data entry form with multiple cascading drop-down menus (such as State, City, Department) where the user selections need to be recorded.
Observed behavior: Unbound combo boxes successfully filter the options, but they do not automatically store the selected values into the respective table record.

Before you start

Ensure you have established proper table relationships in the Relationships diagram and back up your database before modifying form properties to prevent data entry loss.

Solution 1Recommended

Bind Form Controls to Foreign-Key Fields

The most reliable method to save combo box values is to use bound controls connected directly to your table's foreign keys.

Unbound controls are useful for navigation or filtering, but data entry requires bound controls. When you bind a combo box, Access automatically pushes the selected item into the underlying table record.

Open Form Design View

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

Access the Property Sheet

Select the specific combo box (e.g., City). If the Property Sheet is not visible on the right, press F4 or click 'Property Sheet' on the Form Design ribbon.

Set the Control Source

Navigate to the 'Data' tab in the Property Sheet. Click the 'Control Source' dropdown and select the corresponding foreign-key field from your underlying table (e.g., CityID).

Configure the Row Source

Ensure the 'Row Source' property contains an SQL query that filters based on the parent combo box, such as using 'WHERE StateID = [Forms]![YourForm]![cboState]'.

Save and Test

Save your form layout and switch to 'Form View'. Enter a new record, select values from the combo boxes, and verify that the data correctly populates in your backend table.

Bind Form Controls to Foreign-Key Fields

Reference Northwind Starter: If you are unsure how to bind forms, Microsoft's Northwind Starter database template is an excellent reference for examining properly bound forms and relationships.

Solution 2

Apply Database Normalization Rules

Optimize your data structure by only saving the lowest-level key from your cascading combo boxes to prevent data redundancy.

Free Microsoft Office alternative

Looking for a Free, Lightweight Office Alternative?

While Microsoft Access is highly specialized for complex relational databases, you can easily handle extensive data logging, filtering, and organization using WPS Spreadsheet. WPS Office is a feature-rich, free alternative that offers comprehensive productivity tools without the premium subscription.

1. Download the Installer: Visit the official WPS Office website and download the free installation file.
2. Install WPS Office: Run the installer, select your preferred language, and complete the setup process in just a few clicks.
3. Manage Your Data: Open WPS Spreadsheet to import your existing CSV or Excel databases, and utilize Data Validation to recreate drop-down list functionalities.

Use WPS Spreadsheet with built-in data validation and drop-down lists as a lightweight alternative to database forms.Fully compatible with Microsoft Office formats (.docx, .xlsx, .pptx) for a seamless transition.Incredibly lightweight software that runs fast, even on older computers and laptops.Includes Writer, Spreadsheet, Presentation, and an advanced PDF toolkit in one unified app.

microsoft office alternative - wps office

Frequently Asked Questions

Why are my combo box selections not saving to my table in Access?

If a combo box is 'unbound', its Control Source property is empty, meaning Access treats it only as a temporary selection tool. To save the value, you must change the Control Source property to a valid field in your form's underlying table.

What exactly is a cascading combo box?

A cascading combo box refers to a series of dependent drop-down lists where the choices available in the second list are determined by the user's selection in the first list (e.g., choosing 'California' limits the next box to only show cities within California).

Should I save the Region, State, and City values to my Order table?

No. By following database normalization rules, you should only save the most specific identifier, such as the City ID. Because the City table is already linked to the State table, saving higher-level values in the Order table creates redundant data and risks update anomalies.

How do I filter the choices in my second combo box?

You need to modify the Row Source property of the second combo box. Use an SQL query with a WHERE clause that references the name of the first combo box, formatted like: WHERE StateID = [Forms]![YourFormName]![FirstComboBoxName]. Make sure to requery the second combo box in the 'After Update' event of the first.

Office Quick Solutions