[AccessD] 2001 Error - You cancelled the previous operation

After sleeping on this (and I swear I solve all of my difficult problems
this way)....
The answer was obvious: Me.Requery right after the Undo.
Heck, why was that ? Simple: There are few other form level methods to use
anyway !!
Is it a good solution: Absolutely not. I now have to remember the record
number prior to the Add, and then navigate back to it.
That being said, I still could not put the datasheet portion of the form
back to it's original set of records as there is no way of insuring the
first record in the scrolled list appears as #1 in the list. Instead, the
remembered record number shows up as the first in the list. I need a
Screen.Activesheet.FirstRecord settable property.

All in all: It was definitely a bug.....tested in AC2010 - orig release,
using a SplitForm.
I'll bet it's still in AC2007-SP2.


> Mark,
>
>     Could you please furnish the complete code in form's module?
>
> Best wishes,
> A.D. Tejpal