Data validation warning vs error

[mafrank101]

We have a form with a couple of data entry fields that are similar, but one is used much more often than the second. Occasionally a value is entered into the second by mistake. Since sometimes it is OK to enter data into this field, I cannot put a validation rule on it to limit what is entered, but I would like to have a warning pop up that says something like "Are you sure you meant to enter data into this field?".

Is there a way to do this?

We're using Access 2003.

Thanks

[pbaldy]

You can use the before update event of the textbox or form, a Yes/No message box to gather the user's response, and Cancel = True to stop the update if appropriate. Here's an example of how the before update event is used:

http://www.baldyweb.com/BeforeUpdate.htm

[mafrank101]

Thanks, that pointed me in the right direction to get a solution.

I ended up simply using the Code Builder on the Before Update event that essentially said:

MsgBox "Are you sure this is the right information?"

Now if anything is entered into that field it pops this up, which should prompt the data entry people to double check what they did. They can simply click <OK> and move on if everything is correct.

Thanks again!

[pbaldy]

No problemo, glad you got it working.