Hiding Duplicates in a Combo box

  • Thread starter Thread starter David
  • Start date Start date
D

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.
 
In the row source property of your combo box, make sure your SQL statement is
SELECT DISTINCT, not merely SELECT.
 
David said:
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.
Click to expand...


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