I have the Validation rule set to <> NULL and some text in the validation text. I do not want the field skipped over at all so I included this in the BeforeUpdate event field:
Private Sub Active_Name_BeforeUpdate(Cancel As Integer)
If IsNull(Me.Active_Name) Or Me.Active_Name = "" Then
MsgBox "You must enter the Active Name.", vbOKOnly
Cancel = True
Me.Active_Name.SetFocus
End If
End Sub
Is there something I am forgetting? Anything else I should check? If I enter text and delete it everything works just fine. However, if I skip it entirely there is no error message.