Cancel the Update Event

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
That makes total sense. Thanks to both of you!!

Klatuu said:
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.
Click to expand...
 
Back
Top