Alert message

[Unicon]

Dear all
Greetings,

I have an employee table with employeeID and site defined (DB attached). I have another table “attendance”. I just want to feed attendance with concerned employeeID with their pre defined site and if I entered attendance for concerned employeeID with wrong site (different than pre defined site) message to be popup to remind me that “you have entered wrong site for employee”.

How can I do this please advise.

 

[apr pillai]

Check the attendance form with a VBA Subroutine in the attached database.