By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,490 Members | 1,221 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,490 IT Pros & Developers. It's quick & easy.

user alert message

P: n/a
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?

Nov 15 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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?
Nov 16 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.