Access 2007: how can I prevent duplicates in a combo box.

T

techman41973

I have a form where I placed a combo box. I set the row source
property to fill the combo box with data from a specific column in a
table (which can have duplicate values). It works fine, however there
are duplicates in the combo box. Is there a way to instruct the combo
box to NOT show duplicates?
Thanks
 
S

Stefan Hoffmann

hi,

I have a form where I placed a combo box. I set the row source
property to fill the combo box with data from a specific column in a
table (which can have duplicate values). It works fine, however there
are duplicates in the combo box. Is there a way to instruct the combo
box to NOT show duplicates?
Don't bind the table directly as row source to your combobox. Use a
query instead. There you can specify to return DISTINCT results only or
use GROUPing to avoid duplicates.

mfG
--> stefan <--
 

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

Top