eliminating duplicate items in combobox

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

Amos

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top