Limit combo box to unique values

[mark.mcavoy]

I have a combo box on a form with a query as its record source. The bound column is the branch (see sample below). Is there a way to limit the choices displayed in the combo box to only unique values? In other words, can I limit it to not display multiple iterations of the same branch name?


cost_center branch function
2000060001 Administration Administration
2000060002 Code Enforcement Permits/CACD
2000060003 Code Enforcement Electrical Inspection

 

[bob fitz]

Change the query to a "Totals" query and use "GroupBy" in the Totals Row in the design grid.

 

[boblarson]

As long as Cost Center is there the only way you won't be able to do that. That is because each of the cost centers have a different number.

 

[andreas_udby]

If you're just using the Branch field as the rowsource, you can change the SQL statement from SELECT to SELECT DISTINCT, which would then pull one of each different value from the Branch field and use those to populate your combo box.