General discussion

  • Creator
    Topic
  • #2117827

    Access 97 Macro question 1

    Locked

    by learneverything ·

    I have a macro that worked fine when I wanted it to go to a particular control afterupdate and delete the contents (when a condition was met). I now want it to do the same thing to another control for the same conditon. When I step through to the 2nd GotoControl action, I get an error that says “The macro or function set to the BeforeUpdate or ValidationRule property for this field is preventing Microsoft Access from saving the data in the field”. One of the suggested remedies is “Open the macro in the Macro window and remove the action that forces a
    save (for example, GoToControl)”

    I didn’t know that GoToControl forced a save. When you manually tab from one field to another in the same record, there’s no save. What can I do to similate that action in my macro? Any help would be appreciated. Thanks.

All Comments

  • Author
    Replies
Viewing 1 reply thread