Mark A Matte
markamatte at hotmail.com
Mon Sep 3 20:26:28 CDT 2007
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