Error 3059 when ESC is pressed in Access 2007
Posted on 2010-09-21
We have a main form/subform situation that I'm having a bit of trouble with...here's the processing sequence.
1. User enters some data on main form, then opens subform.
2. Enters data on subform and saves. Data is saved to table #2, control returns to main form, data from subform is displayed on main form.
3. User decides they don't want to keep that new data, and presses ESC. In Form_KeyDown, we trap for the ESC key press and delete the data from table #2, the subform data is cleared from the main form.
Or, that's the way it used to work in Access 2003. Now, in 2007, when the user presses ESC, they get the error 3059, "Operation canceled by user".
We need to keep that processing to delete the saved data from the secondary table, so we can't ignore the ESC key press. I've tried trapping for the 3059 error and resuming processing, but that doesn't seem to work, eiither.
Any suggestions would be much appreciated. Thanks!