[AccessD] SQL against recordset

Instead of dbs.OpenRecordset, use a filter on rst1 like this:

Rst1.Filter = "X = ??"  ' set a filter on rst1
Set rst2 = rst1.OpenRecordset(dbOpenSnapshot)  ' Set rst2 as a filtered
recordset of rst1

Charlotte Foust
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
Sent: Monday, September 03, 2007 6:26 PM
To: accessd at databaseadvisors.com
Subject: [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

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com