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

[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

 

[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 <--