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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update subform with combobox change on main form 1
Pause Subform 1
Error 3201 1
Unremovable horizontal scroll bar on subform 1
Access Reference Subform's Control 0
Mimic Split Form with Two Subforms 0
How to always get the top level form reference, when calling from any subform/subform... 0
VBA Syntax for subform record source change 6

Back
Top