Solved Validation Rules on Form Close/Click on Previous record

[ahmad_rmh]

T

The before update event works when you are leaving the record on that form, if you cancel that in the validation code, then that form's After Update event won't be triggered.

Thanks Minty, I have changed to before Insert event, now it's working.

 

[ahmad_rmh]

As I alluded to in the video, you do NOT need to lock the subform to prevent entry. You can simply trap it in the BeforeUpdate event. Like the BeforeUpdate event, this event ALWAYS works and it allows you to put code into ONE vent rather than several which makes the whole process simpler.

Study the form events. Understand what they are used for. The MS documentation is spotty at best so you'll have to wait for future videos from me or find explanations in the forums.

Thanks a lot Pat, I was also thinking to make it more simpler and I will try to make it more simpler as you have suggested now and will update you. You know I am just a beginner and learner so it takes time to get the results.