Alert inputters by colour change or to create an error Message

[Guest]

The users of the database need to know which staff are Restricted and be able
to enter names of nonrestricted staff.

The field in the main table is called Filled By and attached as a lookup is
tblRestrictedStaff and a Form created. I need the tblRestrictedStaff
information to display in the Form in a different colour when the users try
to input any name on the list as these staff cannot be utilized. I have tried
to change the colour of the tblRestrictedStaff through Format [Red], did not
work; through Format Font, does not transfer to Form;created a query in red,
again colour did not tranfer to Form; changed Form colour to red hoping that
the lookup list would stay black; did not work.

Can the colour be changed in the Form?

If not, my next solution would be to create a error message that if the user
tries to enter a name in the field from the tblRestricedStaff an error
message will appear. Unfortunately, I do not have a great deal of experience
creating code and may require assistance.

Thank you for any assistance that you can provide.

 

[Guest]

If these staff names are not allowed to be used, why do you include them?

 

[Guest]

Hi,

The database being used is for a Staffing Office that provides staff to the
nursing units with approximately 20 to 50 requests per day. The restricted
names are agency (outside) staff that are not allowed to work in our
facility. Instead of creating a separate restricted table that the users
(staffing clerks) would need to access everytime they get a name from an
agency, I want to incorporate the restricted names into the filled by field
(where staffing clerks enter the names of the replacement staff) that would
notify them immediately. Does this help?

Thank you for your assistance

If these staff names are not allowed to be used, why do you include them?

The users of the database need to know which staff are Restricted and be able
to enter names of nonrestricted staff.

The field in the main table is called Filled By and attached as a lookup is
tblRestrictedStaff and a Form created. I need the tblRestrictedStaff
information to display in the Form in a different colour when the users try
to input any name on the list as these staff cannot be utilized. I have tried
to change the colour of the tblRestrictedStaff through Format [Red], did not
work; through Format Font, does not transfer to Form;created a query in red,
again colour did not tranfer to Form; changed Form colour to red hoping that
the lookup list would stay black; did not work.

Can the colour be changed in the Form?

If not, my next solution would be to create a error message that if the user
tries to enter a name in the field from the tblRestricedStaff an error
message will appear. Unfortunately, I do not have a great deal of experience
creating code and may require assistance.

Thank you for any assistance that you can provide.