please follow me closely on this one, it's kinda hard to explain ...



i've created a class module which has a PRIVATE (WITHEVENTS) ado 

connection (let's call it cnMODULE) and recordset variable (let's call it 

rsMODULE). on the INITIALIZE event of the module i have initialized 

cnMODULE and rsMODULE. inside the module is a public subroutine that 

declares two (2) local "NEW" ado recordset variable (let's call it RS1 and 

RS2 respectively). i have opened the two recordsets using the connection 

cnMODULE. now here's the problem ...



whenever i run the UPDATE command on the two local recordsets (i.e. 

RS1.UPDATE and RS2.UPDATE) the ABSOLUTEPOSITION of rsMODULE changes to -1.

now, i don't know what happened which affects rsMODULE.



now here's another situation ...



i have added cnMODULE.BeginTrans and cnMODULE.CommitTrans between 

RS1.UPDATE and RS2.UPDATE, the same thing happens, but this time, when i 

try to change the absolute positioning of rsMODULE (either through 

ABSOLUTEPOSITION,FIND,or MOVE methods) i get the an error that rsMODULE is 

in "ZOMBIE STATE"



the bottom line is, "HOW COME rsMODULE CHANGES WHEN I'M NOT EVEN ACCESSING 

IT, WHEN THE ONLY THING SIMILAR IN THEM ARE THEIR CONNECTIONS???"



THANKS IN ADVANCE !!!

HOPE YOU CAN HELP ME ON THIS ONE



Simply Red