witrh ADO populate combobox with unique vale in table

Have a mdb mymdb.mdb in c:\mydir.
In this mdb habe a table mytable
In table have field myfiled

In this field have:

AAAA
AAAA
BBBB
CCCC
CCCC
...
ZZZZ

how to fill with unique value from field the combobox mycombobox.

AAAA
BBBB
CCCC
...
ZZZZ

Thread moved to Database Development forum (the "VB6" forum is meant for questions which don't fit in more specific forums)

There is an article in the Database FAQs about using ADO to fill a combobox, simply add the keyword DISTINCT to your SQL statement that gets the data.