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]
 
Back
Top