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

  • Thread starter Thread starter techman41973
  • Start date Start date
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
 
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?
Click to expand...
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 <--
 
Back
Top