How to Add a Combo Box in MS Access

If your MS Access form still forces users to type values from memory, you’re creating unnecessary friction — and errors. A combo box fixes that instantly.

Microsoft Access holds a 7.25% market share in the database management space, with over 95,000 companies actively using it — ranging from small teams to mid-size organizations managing real operational data. Within those databases, forms are the primary interface for data entry. And the combo box is one of the most powerful controls you can add to any form.

A combo box combines the functionality of a text field and a dropdown list. It lets users either select from a predefined set of values or type in a new entry. The result: cleaner data, faster input, and fewer mistakes. In this guide, you’ll learn exactly how to add a combo box in MS Access — step by step, across every major use case.

What Is a Combo Box in MS Access?

A combo box is a form control that presents a drop-down list of options. When a user clicks the arrow, a list of values appears. They can select from that list — or, if the control allows it, type a custom value not in the list.

This makes combo boxes ideal for fields where:

• The valid values are limited and known in advance (e.g., status types, categories, phone types)
• You want to prevent freeform typos from corrupting your data
• You need users to select a related value from another table (e.g., selecting a customer name that stores a customer ID)

Combo box controls are almost exclusively used in forms, not reports. This is because reports are read-only — the combo box is a data entry and selection tool, not a display tool.

Why Use a Combo Box Instead of a Plain Text Field?

Here’s the problem with uncontrolled text fields: people type inconsistently. “New York,” “new york,” “NY,” and “N.Y.” can all end up in the same column, turning your data into a cleanup nightmare.

A combo box eliminates that problem. It restricts entries to a validated list while keeping the interface intuitive. For fields like Department, Country, Product Category, or Status — where the options are finite — a combo box is always the better choice.

Beyond data integrity, combo boxes improve speed. Selecting from a list takes seconds. Remembering and typing an ID number takes much longer — and introduces error risk every time.

Before You Start: Enable the Control Wizard

Before adding any combo box, make sure the Control Wizard is enabled in Access. This is a one-step setup that saves you significant manual configuration later.

Here’s how to enable it:

1. Open your form in Design View
2. On the Form Design Tools tab in the Ribbon, locate the Controls group
3. Click the small arrow at the bottom-right corner of the Controls list to expand the menu
4. Ensure Use Control Wizards is highlighted (enabled)

If it’s not highlighted, click it to turn it on. With the wizard active, Access will walk you through the setup process every time you add a combo box — automatically configuring the row source, bound column, and display settings.

How to Add a Combo Box Using the Wizard (Standard Method)

This is the most common approach — and the one recommended for most use cases.

Step 1: Open Your Form in Design View

In the Navigation Pane, right-click your form and select Design View. Your form will open in editing mode, showing the layout grid.

Step 2: Click the Combo Box Tool

On the Design tab under Form Design Tools, find the Controls group. Click the Combo Box icon — it looks like a small dropdown field with an arrow.

Step 3: Draw the Combo Box on the Form

Click and drag on the form where you want the combo box to appear. When you release the mouse, the Combo Box Wizard dialog box will open automatically.

Step 4: Choose Your Data Source

The wizard gives you three options:

• I want the combo box to get the values from another table or query — use this when your options come from an existing table (e.g., a Products or Customers table)
• I will type in the values that I want — use this for a fixed, short list that rarely changes (e.g., Home / Work / Cell for phone type)
• Find a record on my form based on the value I selected — use this to create a search control that navigates to a matching record

Select the option that matches your use case and click Next.

Step 5: Select the Table or Query (If Applicable)

If you chose the first option, Access will show a list of available tables and queries. Select the one that contains the values you want to display in the dropdown. Click Next.

Step 6: Choose the Fields to Display

Select the field(s) you want to show in the combo box. If you want users to see a name but store an ID (a very common pattern), add both fields — the ID as the bound column and the name as the display column. Click Next.

Step 7: Set the Sort Order

Choose how you want the list items sorted — typically ascending by the display field (e.g., alphabetically by name). Click Next.

Step 8: Adjust Column Width

Drag the column borders to set how wide each column appears in the dropdown. If you’re hiding the ID column (common when storing IDs but showing names), drag it to zero width. Click Next.

Step 9: Choose What to Store

Access asks: what do you want to do with the selected value? If the combo box is bound to a field in your form’s record source, select Store that value in this field and choose the appropriate field from the dropdown. Click Next.

Step 10: Label the Combo Box

Enter the label text that will appear next to your combo box. Use the field name for clarity. Click Finish.

Your combo box is now created and placed on the form.

How to Add a Combo Box from a Lookup Field

If you’ve already set up a Lookup field in your table, Access can generate the combo box automatically — no manual wizard needed.

Here’s how:

1. Open your form in Design View or Layout View
2. Press Alt+F8 to open the Field List pane
3. Find the Lookup field in the list
4. Double-click it or drag it onto the form

Access will automatically create a combo box bound to that field, using the lookup settings you defined in the table. This is the fastest method when your table is already structured with lookup relationships.

How to Add a Combo Box Without the Wizard (Manual Method)

For advanced users who want full control, you can skip the wizard and configure the combo box properties manually.

Step 1: Open your form in Design View and disable Use Control Wizards in the Controls menu.

Step 2: Click the Combo Box tool and draw it on the form.

Step 3: With the combo box selected, press F4 to open the Property Sheet.

Step 4: On the Data tab, configure these key properties:

• Row Source Type: Set to Table/Query if pulling from a table, or Value List if typing static values
• Row Source: Enter the table/query name, SQL statement, or semicolon-separated value list (e.g., Home;Work;Cell)
• Bound Column: The column number whose value gets stored (usually 1)
• Column Count: How many columns to show in the dropdown
• Column Widths: Set individual column widths (set to 0 to hide a column)
• Control Source: The field in the form’s record source where the value will be saved

Step 5: Switch to Form View to test the control.

This method gives you more flexibility — especially when building cascading combo boxes or writing custom SQL row sources.

How to Create a Combo Box with a Fixed Value List

When your options are short and static — say, priority levels (Low / Medium / High) or a yes/no alternative — type the values directly.

1. Open the form in Design View
2. Add a combo box using the Combo Box tool
3. In the wizard, select I will type in the values that I want
4. Enter each value on its own row in the wizard’s table
5. Click Next, bind it to your field, label it, and click Finish

Alternatively, in the Property Sheet, set:

• Row Source Type = Value List
• Row Source = “Low”;”Medium”;”High”

This approach works well for classification fields, status indicators, or any dropdown with five or fewer consistent options.

Cascading Combo Boxes: Filtering One List Based on Another

One of the most powerful applications of combo boxes in Access is creating cascading dropdowns — where selecting a value in one combo box filters the options in a second.

For example: selecting a Country in the first combo box limits the State/Region options in the second.

Here’s the core technique:

Step 1: Create both combo boxes on the form — cboCountry and cboState.

Step 2: In the cboCountry combo box’s AfterUpdate event, add the following VBA code:

Private Sub cboCountry_AfterUpdate()

    Me.cboState.RowSource = “SELECT StateID, StateName ” & _

        “FROM tblStates ” & _

        “WHERE CountryID = ” & Nz(Me.cboCountry) & _

        ” ORDER BY StateName”

    Me.cboState.Requery

End Sub

This dynamically updates the row source of cboState every time a country is selected, filtering the list to only show states for that country.

Cascading combo boxes dramatically improve form usability and reduce the chance of mismatched data entries.

How to Refresh a Combo Box List

If your combo box is based on a table that gets updated after the form loads, the new values won’t automatically appear in the dropdown. To refresh the list:

• Press F9 while the combo box is selected — this requeries the row source and pulls in fresh data
• Alternatively, add Me.cboName.Requery to a button’s click event or any relevant event in VBA

This is especially useful in multi-user environments where another person may have added new records to the source table while the current user’s form is already open.

Common Combo Box Properties to Know

Once your combo box is created, fine-tuning it through the Property Sheet gives you control over behavior and appearance.

Limit to List: When set to Yes, users can only select values from the list — they cannot type in custom entries. Use this when you need strict data validation.

Auto Expand: When set to Yes, Access automatically jumps to the closest matching item as the user types. This speeds up selection in long lists.

Default Value: Set a pre-selected value that appears when a new record is created. Reduces repetitive input for common entries.

List Rows: Controls how many rows appear in the dropdown before a scrollbar appears. Default is 8; increase for longer lists.

Column Heads: When set to Yes, column names appear as headers in the dropdown. Useful when showing multiple columns.

Validating a Combo Box with the ListIndex Property

A common mistake when validating combo boxes is checking only for Null. If a user opens a record where the previously stored value has since been removed from the list, IsNull returns False — but the value is still invalid.

A more reliable validation approach:

Private Sub Form_BeforeUpdate(Cancel As Integer)

    If Me.cboPhoneType.ListIndex = -1 Then

        MsgBox “Please select a valid Phone Type from the list.”

        Me.cboPhoneType.SetFocus

        Cancel = True

    End If

End Sub

A ListIndex of -1 means no valid item from the list is selected — regardless of whether a value exists in the field. This catches both empty selections and stale values that no longer appear in the list.

Switching Between a Combo Box and a List Box

If you decide a list box would work better than a combo box (or vice versa), you don’t need to rebuild the control from scratch.

In Design View, right-click the combo box, hover over Change To in the context menu, and select List Box. Access will convert the control while preserving most of its property settings.

The key difference: a list box displays all options permanently (no click required), while a combo box hides the list until the user clicks the dropdown arrow. Use list boxes when space allows and you want all options visible at once; use combo boxes when space is tight or the list is long.

Aligning and Formatting the Combo Box

After creating a combo box, it may not align perfectly with surrounding fields. Here’s how to fix that quickly:

1. In Design View, select all the fields you want to align by clicking and holding Shift while clicking each one
2. Go to the Arrange tab in the Ribbon
3. Click Stacked to line them up vertically
4. Use the Size/Space button to make all fields the same height — select To Shortest for a uniform look

Consistent alignment makes your form look professional and is especially important if the database is used by multiple people who expect a clean interface.