HI
I have added some code to a class module to get an ADO recordset which I want to return to the calling module.
After this line of code...
Set GetContactNameRecordset = rsContactNames
...both recordsets are populated but as soon as I close RSContactNames, GetContactNameRecordset also closes.
Should I be doing something else?
I've looked at making a 'clone' but is it that over the top for what I want?
Thanks in advance
I have added some code to a class module to get an ADO recordset which I want to return to the calling module.
After this line of code...
Set GetContactNameRecordset = rsContactNames
...both recordsets are populated but as soon as I close RSContactNames, GetContactNameRecordset also closes.
Should I be doing something else?
I've looked at making a 'clone' but is it that over the top for what I want?
Thanks in advance