ADO & Query help

[NewCoder2]

I'm sure this is easy, I'm just not getting it though.
All i want to do is use an ado connection in vba to create a record set based on my sql statement and then populate my variables with the data from the record set.

But I don't know if this should be in a sub, or it's own function, and I don't know how to put my recordset in to variables.

Thanks for anyt thoughts.

 

[p27br]

maybe this will help :

dim cnn as adodb.connection
dim rs as adodb.recordset
dim myvar as long

set cnn = myconnectionstring
set rs = new adodb.recordset

rs.open "SELECT customerID FROM tblCustomers", cnn

myVar = rs!customerID

rs.close

as to know where to place the code, that depends on what it will be used for.
set rs = nothing
set cnn = nothing