Adding error message

[Guest]

Hello,

I have a form that shows employee info which when opened the user has to
input the employee number to view his/her info. I would like to have a
message appear if the associate is not in the database....Something like
"Please add associate to dtabase". Is this possible? Thanks

 

[Guest]

There is a code you can insert in the "before update" event of the form (I
think) that will check whether the value you have entered is already stored.
Search for the text

"check value exists"

you will get some threads that deal with this.