Combo Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Anyone,
If in a catagory you have mulitple occurances of a item, why does it come up
multiple times in the combo box. Is there a way to just have that item come
up one time in the combo box? For example, under Catagory 1 of a table, you
have apples 6 times, oranges 2 times, and bananas 3 times. In my combo box,
it appears those many times. Is there a way to just have one occurance?

Thanks in advance
Rose
 
Set your combox rowsource property to "SELECT DISTINCT Item FROM Category
ORDER BY Item"
and you'll have one occurrence of each item ordered by item
 
Back
Top