Error 3201 - with subform (ACC 2000)

  • Thread starter Thread starter Hal
  • Start date Start date
H

Hal

I have main form with an "Undo" button. How can I get to work on a subform?
I have the subforms "Form_Error" set to trap the error, but even if I do an
"err.clear", "SetWarnings False" and "Me.Undo" the error message is still
triggered.

Thanks for any help

Hal
 
You cannot use an Undo button on the main form.
Use the Undo button on the toolbar instead (or press the Esc key.)

Before Access can move the focus to the main form to begin processing your
button's Click event, it has to save the subform record. Before it can save
the subform record, it has to process the current control. Your logic cannot
work that way.
 
Back
Top