populating a combo box

[Rebus]

I have a combo box that pulls data from a database table and works fine.
My table looks like this:

field1 field2 field3
37 0.397 0.399 0.402
37 0.392 0.396 0.408
37 0.397 0.412 0.403
37 0.397 0.476 0.403
38 0.398 0.452 0.403
38 0.398 0.409 0.403
38 0.398 0.402 0.404
38 0.398 0.401 0.404

The problem is, I only want the combo box to display one instance of "field1". For example, I want 37 to be displayed only once, instead of twice, and 38 once, and so on...

THANX for any help on this!!!!

[AdrianH]

Not sure if I get what you are after, but as a suggestion. Re the Combo box that pulls data from a DB, how about populating the Combo box with the result of a SQL call with the DISTINCT predicate??

For example, "Select DISTINCT [Field] From [ThisTable] where ...."

Cheers
Adrian