I want to use the IF statment in a before update
I have tables Employees and keys
the keys table has a key no. and person1 to person5 fields
in the form the employee number is put in which shows a name
the next field is the key
I want the IF to lookup in the key table at that key number and see if employee number is in person1 or person2 to person5
if not (Else) show msg box
I have tables Employees and keys
the keys table has a key no. and person1 to person5 fields
in the form the employee number is put in which shows a name
the next field is the key
I want the IF to lookup in the key table at that key number and see if employee number is in person1 or person2 to person5
if not (Else) show msg box