Use the BeforeUpdate event of the control, to trap the value entered by the
user.
Then use the DLookup() function to check for that value in an existing
record of a table or query.
If it is found (or not found - whatever), use the MsgBox() function to
display a message, then set the Cancel arameter of the BeforeUpdate event to
True to keep the user in that field, until he changes the value to something
accetable.
All these things are described in online help.
HTH,
TC
chris said:
I want to create a message box to appear whenever a value is updated in a
control of a form that equals a value of a control in an existing query.
HELP!!!!
