Combo Box

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

 

[fredg]

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.

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]

 

[Al Campagna]

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