Unique value data combo box

**herukuncahyono** · 04-16-2009, 02:22 AM

Hi, I have Combobox.. source data from a table , there are few same data on table list,When I go to combobox dropdownlist view the same data but I didnt want it, I make some way to set view like go to Query property and set a unique value to "yes" but still did not work...please help me
Herukuncahyono

**bhill** · 04-17-2009, 08:30 AM

In the combo's properties, for your row source of the combo box, don't select the table directly. Next to the row source dropdown there is a button with elipses (three dots). Click that. It will take you to a query designer. There you can select your table, add fields, sort, and add a group by, which will display uniques values from the table in your combo box.