A.D. Tejpal
adtp at airtelmail.in
Mon Oct 3 06:40:02 CDT 2011
Mark,
Could you please furnish the complete code in form's module?
Best wishes,
A.D. Tejpal
------------
----- Original Message -----
From: Mark Simms
To: 'Access Developers discussion and problem solving'
Sent: Monday, October 03, 2011 09:52
Subject: [AccessD] 2001 Error - You cancelled the previous operation
After hours and hours of testing this, I came to the conclusion that unless
I trap the vbKeyEscape in the KeyDown event handler, I am unable to add a
new record to a form after an undo has occurred. I get this dreaded 2001
error which appears to be a misleading one.
It appears that an UnDo condition throws the form into a tizzy-state. Any
method of attempting to add a new record after an undo has occurred either
with a RunCommand GotoRecord acNewrec directive or trying to do an AddNew
and Bookmark ... all fail. When I kill the escape key, all is well..but of
course, my users are mad.they cannot undo the record.
Unless I'm missing something , this is definitely a bug, no ?