Combo Box Duplicates

[Bruister via AccessMonster.com]

I am using contents of a table to use in a list in a Combo Box except there
are many duplicate values in the field I wish to use. How can I easily hide
duplcates in my list view in the CB?

 

[Al Campagna]

Bruister,
In the query behind your combo box, use a Totals query, and GroupBy on
that field.
If these values come from your actual table values, you might want to add
a criteria to that query field...
Is Not Null
to not show a null combo selection.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Linq Adams via AccessMonster.com]

In the Select statement for the combobox RowSource, add the keyword Distinct:

SELECT DISTINCT FieldName FROM TableName ORDER BY FieldName