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
Printable View
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.