a simpler way, that doesn't require any VB coding, is :
make a Yes/No box in your employee table and make two queries, 1 with the criteria for the Yes/No set to Yes, and the other set to No.
So when you click on the Yes/No button on the form the Yes (meaning either left the company or the...