Required Field Help

[brandonb]

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.

[NTC]

if you skip it - - - you don't trigger the BeforeUpdate Event !!

put the vb in the AfterUpdate event of a control you are certain will be completed after this control has been skipped....or put it in the BeforeUpdate of the form itself...

[brandonb]

I tried to put it in the afterupdate for the field I want and still had no luck. Does the code look OK? Is there a way to verify it is being checked? I have yet to see an error generated at all from the code.

[NTC]

maybe you don't have nulls or "" maybe you have some blank spaces in those fields...should work...you need to chop it up into pieces and test with known data....

[brandonb]

That's it! Thanks for the help. I just had to use better test scenarios.