Hiding Duplicates in a Combo box

[David]

how do you keep a combo box from showing duplicate names?
I have a combobox bound to a field and it pulls the names in that field,
sometimes the name may appear more than once.

 

[Kirk P.]

In the row source property of your combo box, make sure your SQL statement is
SELECT DISTINCT, not merely SELECT.

 

[Marshall Barton]

how do you keep a combo box from showing duplicate names?
I have a combobox bound to a field and it pulls the names in that field,
sometimes the name may appear more than once.

Use the DISTINCT predicate in the combo box's RowSource
query.