Access 2000 - how to pass a recordset

[Donald Pickering]

I have code which creates a recordset. I want to pass this recordset to
another subroutine.
What is the code to pass a recordset as a function parameter?
Cannot find an example anywhere.

Thank you for your assistance.

 

[Alex Dybenko]

just pass it as any other variable:

dim rst as recordset

set rst=....

call MySub (rst)

....

Sub MySub (rst as recordset)


end sub



--
Best regards,
___________
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

 

[Don Pickering]

thank you!!

just pass it as any other variable:

dim rst as recordset

set rst=....

call MySub (rst)

...

Sub MySub (rst as recordset)


end sub



--
Best regards,
___________
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com