Access 2000 Form Question

I am using Access 2000. I am trying to get a form field to auto generate a value based on what is entered in the field before it. For example if field 1 is employee_id and field 2 is employee_name, I am looking to have the employee_name field filledin according to the matching employee_id that is entered by the form user. Is this possible?