Combo box without duplicates

[ApesMM273]

I have a combo box, which is populated (I used the wizard) to the "Branch" column of a query. However, each "branch" can be listed multiple times, and I want it to only list each branch once. How do I get rid of duplicate values?

 

[Dugantrain]

Go to the Combo's Properties. Select Row Source. Click on the three dots. This will bring up the Query Builder. Click on the Sigma sign in the Toolbar (the button that looks like an 'E'). This will make your query a Group By query, which will return only Distinct Values (i.e. no matter how many times the same data appears in the table, it will appear in the combo box only once).

 

[SydneyGeek]

Another option;
Also in the underlying query for the combo box, select the SQL view.
You'll see
SELECT something
FROM somewhere;

Change this to
SELECT DISTINCT something
FROM somewhere;

That will keep you to single values as well

Denis

 

[ApesMM273]

Excellent!! Thank you both for your help.