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
 

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

Similar Threads

combo box 1
how a combo box populate other combo box.... 2
Dependent Combo Boxes 3
First Subform record gets modified when closing form 3
Combo Box Question 2
Combo box - not in list 2
sum combo box based on other combo box 2
Combo box formatting 1

Back
Top