Auto filling information

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chart - 31 Oct 2007 17:46 GMT

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?

Reply to this Message

Klatuu - 31 Oct 2007 17:58 GMT

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.

Signature

Dave Hargis, Microsoft Access MVP

> 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
[quoted text clipped - 7 lines]
>
> I do have a table that has all this information. How can I get this to work?

Reply to this Message