Getting the current connection

W

William Gower

I am writing some code in a module to open an ado recordset and then just
loop through the recordset and do something. How do I tell it that I want
to open a recordset to the current database. I knew how to open an access
connection in a vb app but i am thinking that there should be an easy way to
do it inside of access.

rsEmail.Open "Select email from member where email is not null"
rsEmail.MoveFirst

etc.
 
Top