Access 2007

J

Jeff Kaufman

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top