[AccessD] 2001 Error - You cancelled the previous operation

I never let Access Add New, I always use unbound controls, and validate
field by field, and then use SQL and refresh the form... and I don't have
these problems  ;-)

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Simms
Sent: Monday, October 03, 2011 12:23 AM
To: 'Access Developers discussion and problem solving'
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 ?

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com