I have a form based on the employee id. The form is used to show employees swapping with another employee. I enter the first employee id and access automatically completes the information. I need to enter the employee id of the person working for them on the same form. The data comes from the same table. How can I get this to work?