Help with combo boxes in forms

  • Thread starter Thread starter spidey3721
  • Start date Start date
S

spidey3721

Hello - somewhat of a newbie here.

I am trying to tie all entries from a table's column into a pull down combo
box on a form, for example - a column that may list the type of animal (dog,
cat, horse, etc.).

When I link this column as the data source of the combo box it shows
duplicates when I pull it down on the form, for the table has many of the
same entries (dog, cat, cat, cat, horse, horse, dog, dog, dgo, etc...).

How do I make the combo box only show each unique entry only once in the
combo box ?

Thank you....
 
How do I make the combo box only show each unique entry only once in the
combo box ?
Click to expand...

Use a Query as the RowSource for the combo; select only the fields you
want to see and/or store; and set the Unique Values property of the
query to True.
 
Back
Top