I have two tables that are used in multiple sub's, for different purposes, in the same module.
I have tried using different "Dim rsx as", "rsx.close and "rsx = nothing" with "x" being different in each sub.
Trouble is the ".move" in one instance is changing the position in all instances of the recordsets.
They are acting as if there is only one instance of each recordset regardless of how they are instantiated.
How do I return each instance of the recordset to it's previous position?
I have found a point of recursion and corrected that but my question stands.
I have tried using different "Dim rsx as", "rsx.close and "rsx = nothing" with "x" being different in each sub.
Trouble is the ".move" in one instance is changing the position in all instances of the recordsets.
They are acting as if there is only one instance of each recordset regardless of how they are instantiated.
How do I return each instance of the recordset to it's previous position?
I have found a point of recursion and corrected that but my question stands.