CancelEvent

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

High all.

I want to restrict the user to continue to the next field if an iF
expression Is not fulfilled in a fields after update event…

Do I use the CancelEvent for this or are there other ideas…

Thanks!
 
Put code in the control's BeforeUpdate event (not the AfterUpdate event),
and set Cancel = True if the condition isn't met. That will prevent them
from moving on. (You might want to pop up a message box so that they know
why they can't move on!)
 
Thank you Douglas, this helps a lot.!

Douglas J. Steele said:
Put code in the control's BeforeUpdate event (not the AfterUpdate event),
and set Cancel = True if the condition isn't met. That will prevent them
from moving on. (You might want to pop up a message box so that they know
why they can't move on!)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)





.
Click to expand...
 
Back
Top