I have a general question on accessing recordsets

My VBA creates a recordset in module1.

I purposefully did not close the connection or the recordset.

I would like to be able to re-use the recordset in a couple of different modules (say 2 and 3).

Is this even possible? Im looking for any sites, literature, etc that can help. Any direction you can give is greatly appreciated.

Thanks in advance.