eliminating duplicate items in combobox

  • Thread starter Thread starter Amos
  • Start date Start date
A

Amos

How can I eliminate duplicate items in a combobox that's bound to a dataset
field? The combobox is tied to field "State" but in the dataset there may be
several records for one state:
Sstate Num
PA 1
PA 2
PA 3

In this case, the combobox would display PA three times. So I can't
eliminate it from the data.

Thanks.
 
I can't use distinct because all records are different. The only field that
repeats itself is State:

State Num
PA 1
PA 2
PA 3

Even if I use distinct, the State will be repeated. Is there any other way
this can be done within the combobox?

Thanks,
Amos
 
Back
Top