CancelEvent

[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!

 

[Douglas J. Steele]

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!)

 

[Peter]

Thank you Douglas, this helps a lot.!

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!)





.