[AccessD] SQL against recordset

Why do you want to do this.  Or, what are you trying to accomplish?  Why not
just open a second recordset?  The criteria are the same, yes?

Rocky
 




 	
	

-----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

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.484 / Virus Database: 269.13.2/985 - Release Date: 9/2/2007
4:32 PM