When my users enter a number that is out of spec, I want a message to appear saying "Out Of Spec". This will prevent them from moving on until they click OK. They need to notice that they are out of spec. The validation rule feature doesn't allow them to move on unless the data meets a criteria. They need to be able to move on with the data the way it is. Ideas appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Message box
- Thread starter shelspa
- Start date
In the BeforeUpdate event procedure of the control you display a Yes/No or OK/Cancel message box if the number is out of spec and you set the Cancel argument to True if the user don't click the OK or Yes button.
Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
- Thread starter
- #4
VBA needs this syntax:
If Me!Site_1_Index > 1.965 and Me!Site_1_Index < 2.015 Then
'...If that is good then do nothing
Else
MsgBox "Must be between 1.965 and 2.015"
Cancel = True
End If
HTH RuralGuy (RG for short) acXP winXP Pro
Please respond to this forum so all may benefit
If Me!Site_1_Index > 1.965 and Me!Site_1_Index < 2.015 Then
'...If that is good then do nothing
Else
MsgBox "Must be between 1.965 and 2.015"
Cancel = True
End If
HTH RuralGuy (RG for short) acXP winXP Pro
Please respond to this forum so all may benefit
- Thread starter
- #6
- Thread starter
- #8
- Thread starter
- #9
- Status
Similar threads
- Locked
- Question