Cancel the Update Event

[Guest]

I have a form that requires data entry. One text box must have dated before
one can continue updating. I also have an "OK" command button and a "Cancel"
command button.

In the After Update Event is where I created code that pop ups a form
telling the user that this text box must have data. This After Update Event
continues to bring up this message if I hit the "Cancel" command button. How
do I cancel the After Update when the "Cancel" button is clicked.

Thanks for all the help!!!!

Rob

 

[George Nicholson]

BeforeUpdate events can be canceled, AfterUpdate events can not.

 

[Guest]

Move your code to the Before Update event and and the line
Cancel = True

Notice the naming of the events -- After Update is too late. It is already
happened, Before Update is where you check to be sure it is okay to continue.

 

[Guest]

That makes total sense. Thanks to both of you!!

Move your code to the Before Update event and and the line
Cancel = True

Notice the naming of the events -- After Update is too late. It is already
happened, Before Update is where you check to be sure it is okay to continue.