text message on a calculation

[shelspa]

I want an error message to appear when 3 or more consecutive records have a value in a field that is greater than a number or less than another number to indicate an out of control process. I would like for the message to appear after the third value was entered on a form if at all possible. Ideas?

 

[shelspa]

Also, Is it possible to require a password to clear messages?

 

[andylec]

For the first question, assuming the data is entered via a form, after each record is entered increment a variable by 1 if the value falls outside the allowable range, and reset it to 0 if inside the range. Then check to see if it equals 3.

Second question. What messages are you referring to? If you are creating the messageboxes using MsgBox then you could use an InputBox instead, or maybe a custom form to emulate MsgBox.