G
Guest
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!!!!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
TC
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
HELP!!!!
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
control of a form that equals a value of a control in an existing query.chris said:I want to create a message box to appear whenever a value is updated in a
HELP!!!!