Auto filling information

[Guest]

First, I would like to say I am using Access 97. I am using it at work
because for one reason or another they can not upgrade higher than 97 due to
Security flaws, or losing information. With that said, I will ask my
question.

I am building a form for employees to list the projects they are working on.
I have a query that will allow the drop down box to list all employees
names. What I want to do is have the information such as their employee ID,
phone number, and email populate when they choose their name.

I do have a table that has all this information. How can I get this to work?

 

[Guest]

Create a combo box that has a query that includes the fields you want to use.
Then in the After Update event of the query populate the controls on the
form with the columns from the combo box.