Message box when particular values entered on form

[Guest]

Similar to Validation rule, I want to apply a rule that generates a message
"out of specification", but still allows the value to remain.

 

[Jeff Boyce]

Add code to the control's BeforeUpdate event that tests and displays your
message.

Good luck

Jeff Boyce
<Access MVP>

 

[Guest]

I could do with knowing what code to add.

Thanks

 

[Douglas J. Steele]

If Me.TheTextBox = "Particular Value" Then
MsgBox "Out Of Specification"
End If

Replace TheTextBox with the name of the actual control containing the value
to be checked, and "Particular Value" with the vallue to compare it to.