Field 3 is required if fields 1 & 2 are not equal. One the lostfocus event of field three, I want the validation code to run. . .not sure what to do. Something like this (you'll see I'm very new to VB. . .don't know how to deal with ANDIF and Not=):
Private Sub Notes_LostFocus()
Dim StrMsg As String
If IsNull (Notes) AndIf Field1 is not equal to field2
blah blah blah I'm clueless Then
StrMsg = "You must enter your case notes before adding a new DRG", vbOK
I want the OK button to set focus on Field 3.
Please help!
Private Sub Notes_LostFocus()
Dim StrMsg As String
If IsNull (Notes) AndIf Field1 is not equal to field2
blah blah blah I'm clueless Then
StrMsg = "You must enter your case notes before adding a new DRG", vbOK
I want the OK button to set focus on Field 3.
Please help!