I am currently using Microsoft Access 2007 and I am trying to set up a form
in which I can select a name from a drop down menu and have it return the
results in the fields below. My table currently has the following items in
it.

ID - Employee ID number (Listed as the Primary Key)
FirstName - Employee First Name
LastName - Employee Last Name
Separation_Date - Employee Separation Date
Email_Address - Employee Email address

I would like to be able to select the employee name from a list.. and then
have all the above fields show below that information and then be able to
select another employee from the list and have my data below change to their
data. How do I do this.

Thanks