How to hide peretitive values in a combo box

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

Guest

The combo box that I am now using is pulling information from a Table. The
Table has repetitive values. So when I use the combo box you will see, A,
repeated 4 times and then the letter B repeated four times. Is there anyway
to set this combo box up so that it won't show repetitive values.
 
Change the query that creates the list of values to show "group by". This is
done with the Sigma sign button on the Query Design tool bar.
 
The combo box that I am now using is pulling information from a Table. The
Table has repetitive values. So when I use the combo box you will see, A,
repeated 4 times and then the letter B repeated four times. Is there anyway
to set this combo box up so that it won't show repetitive values.
Click to expand...

Either use a totals query as Tynerr suggests, or base the combo box on
a Query; view the query's Properties and set its Unique Values
property to True.

John W. Vinson[MVP]
 
You must log in or register to reply here.

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

cant get cbo to stop outputting key# 0
Unique values in a combo box 3
Save values displayed in unbound text fields from combo box to tab 3
sum combo box based on other combo box 2
Combo box help 1
selecting multiple values on list box 2
combo box basic question...? Access 2007 2
Combo Box Lookup Value 4

Back
Top