Combo Box/Query Unique Names Only, How?

  • Thread starter Thread starter BobG
  • Start date Start date
B

BobG

Background: Created a simple table and form that has
fields for traveler, airline and date. In my table and
form each field is presented as a Lookup, ComboBox. The
CombBox works as expected but I want to limit the ComboBox
items to unique entries.

Present ComboBox Selection: Bob,Joe,Bob,Sam,Joe,Joe
Desired ComboBox Selection: Bob,Joe,Sam

Solutions? Many thanks.
 
You can do this by setting the rowsource as a query and
setting the query's "Unique Values" property to true.
Or, by right clicking in the query design grid and
choosing "Sum Totals" and then grouping by specific
fields.

If your combo box is currently using a table as the row
source, just click the button to the right of the table
name (it just has three dots on it), and Access will open
the query builder with a query based on that table. Then
just do either of the above.
 
Back
Top