How Do I Populate a Combo Box using DAO and ADO

[pcdaveh]

I'm new to VB and I'm trying to Populate a Combo box from a
Ms Access 2000 MDB. I'd like to get an example of how to do this using both DAO and ADO using the ODBC.

Thanks

DaveH

pcdaveh@prodigy.net

 

[Karl Blessing]

you use DAO and ADO at the same time (especially not to the same database since, I remeber DAO is only singlethreaded, and the ADO connection might disrupt it) but that really depends why you want to do both, I can see DAO being used on a local mdb, while you use ADO for SQL perhaps.

why do you want to do both, and do you already know generally how comboboxes work, and how to open a recordset in ADO?
Karl
kb244@kb244.com

http://www.kb244.com

Experienced in : C++(both VC++ and Borland),VB1(dos) thru VB6, Delphi 3 pro, HTML, Visual InterDev 6(ASP(WebProgramming/Vbscript)

http://www.brainbench.com/transcript.jsp?pid=629151

 

[pcdaveh]

Thanks for your reply. I'm in the middle of working with a consultant and just got an email notification. I'll reply back in detail this afternoon.

Thanks again!