Office Settings & Configuration

Fix a Microsoft Access 2016 Combo Box and Show Distinct Query Values

Huda QurayshiHuda Qurayshi Nov 22, 2026 868 views

Question details

Configure an Access combo box or list box to display distinct query values and allow users to select one.

Make an Access 2016 Combo Box Selectable with Distinct Query Values
Product
Microsoft Access 2016
Device & OS
not provided
Scenario
A form control uses a query containing duplicate items, and the user wants a distinct selectable list.
Observed behavior
The control displays query values but does not allow the user to select them.
Before you start

Open the form in Design View and identify the combo box or list box, its Row Source, and the form field that should store the selection. Confirm the query and field names before editing the SQL.

Solution 1Recommended

Use a distinct row source and check the form control settings

Use this method to remove duplicate display values and make sure the control and form permit selections.

A row-source query does not have to be editable for a user to choose a value from it. To save the selection, however, the control must be bound to a suitable writable field in the form's record source.

1
Open the control properties

Right-click the form in the Navigation Pane and choose Design View. Select the combo box or list box, then open Property Sheet from the Design tab.

2
Set a distinct row source

On the Data tab of the Property Sheet, set Row Source Type to Table/Query. In Row Source, enter: SELECT DISTINCT [Game Field] FROM [qry_Non_Input_Game_List] ORDER BY [Game Field]; Replace the query and field names if yours differ.

3
Bind the selection if needed

On the Data tab, set Control Source to the field in the form's record source where the selected value should be saved. Leave it blank only if you need an unbound control and do not need Access to save the selection to that field.

4
Check selection and edit settings

On the control's Data tab, set Enabled to Yes and Locked to No. For a bound list box, set Multi Select to None on the Other tab. Select the form in the Property Sheet and check that Allow Edits is Yes and its Record Source is updateable when saving changes to existing records.

5
Test the form

Save the form, switch to Form View, and select an item. If the control is bound, move to another record and return to confirm the value was saved.

Use a distinct row source and check the form control settings
Check the bound column: For a multi-column control, check Bound Column on the Data tab. It determines which column's value is stored, which may differ from the displayed text.
Free Microsoft Office alternative

Manage Simple Item Lists in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar interface for working with Office files. Use WPS Spreadsheets for simple item lists and move compatible Excel files between applications. It does not replace Access for configuring an Access database form.

Organize and review item lists in a spreadsheetOpen and edit Microsoft Excel XLSX files for easier migrationUse a familiar spreadsheet interfaceWork with a free, lightweight Office alternative
microsoft office alternative - wps office

Frequently Asked Questions

How do I remove duplicate values from an Access combo box?

In the control's Property Sheet, set Row Source Type to Table/Query and use SELECT DISTINCT in Row Source, such as SELECT DISTINCT [Category] FROM [Products] ORDER BY [Category];.

Why can I see items but not select one?

Check the control's Enabled and Locked properties in its Property Sheet. If the value must be saved, also check the form's Allow Edits property, the control's Control Source, and whether the form's record source is updateable.

Does the combo box row-source query need to be editable?

No. A read-only row-source query can still supply selectable values. The form's record source and bound field must be writable if the selection is to be saved.

What is the difference between Row Source and Control Source?

Row Source supplies the choices shown in the control. Control Source identifies the form field that stores the selected value; an unbound control has no Control Source.

Can a bound list box save multiple selected values?

A bound list box does not save multiple selections directly to its Control Source. Set Multi Select to None for a single saved value, or use a separate approach to process multiple selections.