How do you eliminate duplicates in a bound combo box?

[Lisa]

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?

 

[Corey-g via AccessMonster.com]

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