Duplicate records in combo box

[Guest]

Hello,

I am currently working on a program in access 2003. We have a combo box,
but there are a lot of duplicate text in the combo box, we used the wizard
"Find a record on my form based on the value I selected in my combo box.".
How exactly do I have each duplicate value only show once?

Thanks

 

[Allen Browne]

Add DISTINCT to the combo's RowSource query statement.

For example, if the RowSource is the Gender field, and lots of records have
M for male and F for female, use:
SELECT DISTINCT Gender FROM Table1;

A better solution is to create another table that has the valid choices for
the combo, and create a relationship to your existing table. Then use the
lookup table as the RowSource for the combo.

 

[Guest]

Hello,

This worked great, I knew there was a way to do this but my mind blanked.

Thanks for your help,

Andy