Autofill in Access

I am working on a form and what I want to happen is when I enter a SSN (either in a text box or a combo box), a start date and an end date I want all the employees information to fill in the designated text boxes. The data is being written to a separate table but the fields wont update unless i close the form and reopen.