Conditionally prevent moving to another record

[Eutychus]

I want to prevent users from leaving a record on a form based on the values in the controls on the form. I can use the form's AfterUpdate event to check the values in the controls, but I can't find a way to stop moving to another record or closing the record if the values in the controls are missing. The conditions for which fields have to have values is a little complex. But I need to be sure certain fields have been completed based on values in other fields before moving to the next record. I plan to use VBA to do this.

Can you help?

 

[MajP]

That is the whole purpose of the before update event. It has a cancel parameter. You do your error checking here and cancel if needed.

https://msdn.microsoft.com/en-us/vba/access-vba/articles/form-beforeupdate-event-access