Well, I'm not sure if this is what you want, but if you want to declare let's say a global recordstet on a VB module you would do something like:
Public Your_RS_Name As New ADODB.Recordset
Is this what you were asking for? If you need more help let me know.