________________________________________________________
Zameer Abdulla
Help to find Missing people Education's purpose is to replace an empty mind with an open one.
~Malcolm S. Forbes~
For example I would like to bypass or cancel the update to a record before the after update event. Or I would like to set up a before update event while I'm in the Enter or Focus event.
Is there anyway that I can set those events in VBA if I'm in another event like set True After Update or set cancel the After Update events.
Hopefully, this explanation help. Thank you everyone.
To cancel the update to a record before the after update event, you use the forms before update event, and issue a
[tt]Cancel = True[/tt]
If you cancel the before update event of the form, the after update event of the form will not trigger.
But - I second ZmrAbdullas question - I still haven't the foggiest what you're really trying to achieve ... except you're talking about form events, which is really more appropriate in the forms forum (forum702)
Non easy but fully controlled method is to use unbound form.
Add/Edit, Validate, Discard/Update record
________________________________________________________
Zameer Abdulla
Help to find Missing people Education's purpose is to replace an empty mind with an open one.
~Malcolm S. Forbes~
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.