[AccessD] OpenRecordSet question

jwcolby jwcolby at colbyconsulting.com
Fri Aug 7 17:33:44 CDT 2009


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




More information about the AccessD mailing list