[AccessD] OpenRecordSet question

Spot on!

I have experienced this.

Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: 07 August 2009 23:34
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] OpenRecordSet question

Unfortunately that doesn't always work.  If RS loses scope the value of RS
"goes away".  Inside of 
the same function this will always work, but if you try to pass the
recordset off to another 
function, or a field off to another function, then things fail to work as
you expect.

I had enough run-ins with this that I decided just to bite the bullet and do
the dim db statement as 
a matter of habit.

John W. Colby
www.ColbyConsulting.com


Stuart McLachlan wrote:
> As a matter of style, I never bother to Dim db.
> 
> I just use:
> Dim rs as DAO.Recordset
> Set rs = Currentdb.OpenRecordset("myQuery")
> 
> 

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