Populate combobox from ODBC sql query?

Hello,

Wondering if is it possible to populate a combobox with values from a single column sql query.

1: I do not want to have the recordset returned to a query table and then have combobox populate from query table (trying to cut out the "middleman")
2: I have odbc connections only, I do not have the privledges to add on the ADO add-ons, and if I can get it, my clients will not have it.

so,
The connectionstring I use is this

Please Login or Register  to view this content.

Any help would be greatly appreciated