1. User navigates records using datagrid bound to recordset using client-side cursor.
2. User creates new record and attempts to move to new one.
3. WillMove event traps this & prompts user 'save changes?'.
4. User specifies 'yes' & changes are saved.
5. The record the user selected becomes current record.
6. User immediately returns to the record just created above.
7. As soon as user attempts change, code attempts lookup on database to check no-one has changed the underlying data since the client-side recordset was retrieved/ refreshed.
7. Crash!
To be honest,I think there IS an underlying problem of a recursive nature where the WillMove event is effectively triggering itself. Although the recursion should have 'resolved itself' by the time of the crash, I think it could be indirectly responsible for some 'confusion'.
I wish the code were simple enough to post but there are reams of the stuff!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.