Message box when particular values entered on form

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Add code to the control's BeforeUpdate event that tests and displays your
message.

Good luck

Jeff Boyce
<Access MVP>
 
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.
 
Back
Top