Recent content by optiaccess

Thanks for your suggestions, and you are both right about the .Undo. I forgot to mention that I Just want to prevent some empty fields. What I'm looking for is a way to temporarily keep the required property while I finish my code on beforeUpdate, but I guess I'll have to disable required on...

Hello there, I have a form in which I want to validate fields. The following code is working well in the Form_BeforeUpdate event Private Sub Form_BeforeUpdate(Cancel As Integer) If IsNull(Me.OrderNumber) Or Me.OrderNumber& "" = "" Then MsgBox "Must enter Order Number", vbInformation...