[AccessD] SQL against recordset

Hello All,

This might sound odd...but I want to use VBA to open a recordset...

"Set rst1 = dbs.OpenRecordset("SELECT symbol from tblList...."

then I want to open a new recordset by running an SQL statement against the 
first recordset.  I don't know if this is possible...and if so...what syntax 
would I use to reference the recordset?

"Set rst2 = dbs.OpenRecordset("SELECT symbol from rst1..."???????

Any thoughts?

Thanks,

Mark A. Matte

_________________________________________________________________
A place for moms to take a break! 
http://www.reallivemoms.com?ocid=TXT_TAGHM&loc=us