Pop Up Message on Condition

[Pharcyde]

Stooopid Question - no laughing

This is simple, but as I'm a little thick, I cant do it, so hopefully someone out there can help me....

How do I get a pop up/error message box to appear when a condition (whixh is user specified) isn't met in a form?

Thank ya, Lee

 

[Fizzio]

It depends.
You could use the Validation Rule and message for a form control but the better option is to use the message box
ie

If [i]{Your Condition not met}[/i] Then
msgBox "Your Message",ButtonOptions,"Messagebox Title"
End if

This is the simplified version of the VBA you will need. If you do not know how or where to put this. Explain in a little more detail how you want the message to be triggered.

 

[Pharcyde]

wahey!

thats perfect, thanks a lot buddy