How to hide peretitive values in a combo box

  • Thread starter Combo box and Queries
  • Start date
C

Combo box and Queries

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.
 
T

tynerr

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.
 
J

John Vinson

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