Adding pop up comment to Access Form

Question

I have created a form and am using Conditional Formatting whereby when users enter in a value in a field that is below their target, the field will turn red (i.e. if the Target for Sales for a week is $5,000, and the value entered in is $4,500, the field containing the value will turn red).  I am telling all users that when their cell turns red, they need to provide comments in a section on the form.  Is there a way to create a pop-up message to where if users enter in a value below target, the pop up message will come up?  How do I customize the pop up message to say what I want (which would be to provide comments since they are below target).

Answer 1

Something like...

If [FeildThatHoldsTheTargetSales] < 5000 Then

MsgBox "Please enter explanation below!", vbExclamation, "Comments"

End If

---

-- Gina Whipp 2010 Microsoft MVP (Access) Please post all replies to the forum where everyone can benefit.