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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

duplicate form after selecting value in combobox 0
Need combo box to refresh when moving to new record 2017 1
Can you auto write AddItem VBA code to a form to populate a Combo 5
Duplicates in Combo boxes 3
How to switch combo boxes? 1
combo box - bound column 2
Filter form using multiple combo boxes selection 6
List Fields Name in combo box 3

Back
Top