Combo Box

  • Thread starter Thread starter Kyhigh
  • Start date Start date
K

Kyhigh

When making my table, I chose to get the data from as a combo box from the
table itself. When I put it on a form, it shows multiple values. Is there a
property I am missing either on the form or the table that gets rid me of
duplicate values showing? I am trying to avoid making queries for tables just
to get rid of the duplicate values on the form's combo boxes.
 
When making my table, I chose to get the data from as a combo box from the
table itself. When I put it on a form, it shows multiple values. Is there a
property I am missing either on the form or the table that gets rid me of
duplicate values showing? I am trying to avoid making queries for tables just
to get rid of the duplicate values on the form's combo boxes.
Click to expand...

And what is wrong with making a query?
You don't need to actually make and save a query object.
You can set the combo box row source property to an SQL statement:

Select Distinct TableName.[FieldName] from TableName Order by
TableName.[FieldName]
 
Kyhigh,
Make the combobox's rowsource query, a Totals query,
with a GroupBy, on that field.
Now the query will only deliver one instance of each value to
the combobox selections.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Back
Top