General discussion

Locked

Access 97 Macro question 1

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.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Access 97 Macro question 1

by MarkS@Blue In reply to Access 97 Macro question ...

Not sure, butwhen I get similar problems I try this...

Create another macro for the second action (without the validation), and call it from the first macro.

Collapse -

Access 97 Macro question 1

by learneverything In reply to Access 97 Macro question ...

Thanks, but it didn't help in this case.

Collapse -

Access 97 Macro question 1

by learneverything In reply to Access 97 Macro question ...

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums