How do you eliminate duplicates in a bound combo box?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with a bound combo box that has duplicate numbers in it. I
need the duplicates removed. How do I eliminate the duplicates from the drop
down?
 
Hi Lisa,

I think that you will need to change the 'Row Source' of the combo box to a
query, and the query needs to select only the distinct values. You can leave
the combo box bound to the control source it is alredy bound to.

HTH,

Corey
 
Back
Top