Well, a recordset is a coolection of records (rows) of a db table.
So, when you open a recordset with a Sql query, it get's filled with the query results (or not filled at all if the query dosen't return any results.
But if it does get filled, you must move along the returnd rows to get their data.
example:
Code:
set rec=new adodb.recorset
set conn=new adodb.connection
conn.open "your connection string" 'do a google search ob ado connection strings if you don't know what this is.
'also check my site's code lib. I posted there a function to build connection strings easy.
rec.open "select * from myphonebook order by name,phonenr", Conn ' load query results into the recordset
do while not rec.eof 'loop through all the results
printer.print rec.fields("name") & vbTab & rec.fields("phonenr")
'print the name and phone nr. of the current row separated by a TAB
rec.movenext 'move to the next row on the recordset
loop
rec.close 'close the recordset
conn.close 'close the db connection
set rec=nothing 'destroy the object
set conn=nothing 'destroy the object
printer.enddoc 'start printing
hope it helps