user alert message

[Hph]

I need to alert my users upon attempt to enter a hiring request (on a
form) to not hire due to grade level of candidate. Candidate grade
level is in a separate table from those that the form is designed from.
If I add the table to the forms query I run in run time errors. Here
was my statement: In the field "Site" upon update If Me.grade = 5
Then Msgbox "GRADED LEVEL 5 - DNH"

The request from my users was "Can you disable use of this form (adding
a work assignment to candidates record in a table called [To Be Hired]
via the forms query [To Be Hired query] when the candidate is graded as
a level 5? in the tblSpecialties. The form itself is a subform to a
mainform called [Hire Request]. [Hire Request] form shows their name
and personal information from a table called [Operations]. All of the
pertinent information is then merged into an MSWord document to send a
hire letter and produce other forms. Any advice on how to accomplish
this?

[lesperancer]

so 'grade' is not a field on your form, it comes from another table ?
try, if (dlookup("grade","othertable","where clause") = 5 then

Hph wrote:

I need to alert my users upon attempt to enter a hiring request (on a
form) to not hire due to grade level of candidate. Candidate grade
level is in a separate table from those that the form is designed from.
If I add the table to the forms query I run in run time errors. Here
was my statement: In the field "Site" upon update If Me.grade = 5
Then Msgbox "GRADED LEVEL 5 - DNH"

The request from my users was "Can you disable use of this form (adding
a work assignment to candidates record in a table called [To Be Hired]
via the forms query [To Be Hired query] when the candidate is graded as
a level 5? in the tblSpecialties. The form itself is a subform to a
mainform called [Hire Request]. [Hire Request] form shows their name
and personal information from a table called [Operations]. All of the
pertinent information is then merged into an MSWord document to send a
hire letter and produce other forms. Any advice on how to accomplish
this?