That's basically what I have if I understand what you're saying. To originally set up the form I followed the method in a youtube video entitled, "Access 2010: Auto populate fields using a combo box in forms," to originally set it up.
On the form I have one combobox "EmpIDAutofill" that pulls...