Hello,
I have the following code in order to validate repsonses made on a form.
It works but flags up regardless of the repsonse. (i.e. None) Which the point of the rule is if "none" is answered then a renew year is not required and visaversa
Code:
Private Sub Form_AfterUpdate()
If Me.[Entrance Doors - Flats (Fire Doors)] <> "None" And Nz(Me.[Entrance Doors - Flats (Renew Year) 20 LE], "") = "" Then
MsgBox "If an Entrance Door is Selected a Renew Year Must be Entered!"
[Entrance Doors - Flats (Renew Year) 20 LE].SetFocus
Cancel = True
Exit Sub
End If
End Sub
Any help much appreciated.