MsgBox Based on Text Box Value - More Help Needed

[diensatthan]

I need to know how to display a message whenever the value of a bounded Text Box (Enabled = No) on a form is ZERO when navigating. Thanks.

Mile-O-Phile suggested the following code:
------------------------------------------------------
Private Sub Form_Current()

If Me.txtYourTextbox = 0 Then
MsgBox "Hey, it's a 0 value!", vbInformation, "0 Found"
End If

End Sub
--------------------------------------------------------

This solution almost works except when the First record is applicable; MsgBox is displayed PRIOR to the form is opened.

 

[Full_Williams]

Try putting that code on the "On Exit" event of each textbox if you want the message to pop up during the navigation.

 

[Mile-O]

Try and keep it all in the original thread