ACCESS: Combobox Duplicates

[gheyman]

I have a table that has a Field called "Status". There are five types. The types, like "Active" are listed numerous times in various rows in the table (As are the other 4 types of status).

I need to make a Combo-Box that has a list of the different choices. If I just use the table field as my Combo-box source my list shows duplicates. Is there a way to remove duplicates from the list that shows in the Combo-box?


Unfortunately, that table that I refer to is a Linked table that I cannot modify. In that table this field is not based of a list from a sub-table. I think they set that filed up as a value list.

 

[ranman256]

cant you make a table of the Statuses?
and the combo load from that.

 

[xenou]

You should also be able to load the combobox with a select distinct query.

 

[gheyman]

What is a Select Distinct query?

 

[xenou]

select distinct is a type of query that selects distinct values (no duplicates).
Example:
select Status from Table1 --> all statuses (with duplicates)
select distinct Status from Table1 --> distinct statuses (no duplicates)