Drop Down List populating other text boxes in a data access page?

I've got a feeling that the answer to this question is going to be so easy
that I'll end up smacking myself in the head for not thinking about it,
anyway, here's my question.

Lets say that I am creating a database that tracks the hours worked by
employees. What I'm trying to do is set up a data access page where I can
select the employee's name from a drop down list, and have it display the
hours the employee worked in a seperate text box for each day. As of right
now I can get the drop down list to display the names of all the people in my
table, but I can't get Access to pass the other information to the other text
boxes. Any help would be appreciated. I've read over all 30 articles
releating to this in the Office Assistance area but that just confused me
more.
Thanks again for any help.

* create a query that has all the fields you will want (including the drop
down) - give it a unique name. and be sure to open it so it is populated
with data.
* create a new form - based upon that query
* first add a list box - and when the listbox wizard launches be sure to
select the correct option that it selects the full record for the data
selected
* drag all the other fields from the field list onto your form

do a quick & dirty run - don't worry about it looking good....and then test
--
NTC


"25UinChatt" wrote:

I've got a feeling that the answer to this question is going to be so easy
that I'll end up smacking myself in the head for not thinking about it,
anyway, here's my question.

Lets say that I am creating a database that tracks the hours worked by
employees. What I'm trying to do is set up a data access page where I can
select the employee's name from a drop down list, and have it display the
hours the employee worked in a seperate text box for each day. As of right
now I can get the drop down list to display the names of all the people in my
table, but I can't get Access to pass the other information to the other text
boxes. Any help would be appreciated. I've read over all 30 articles
releating to this in the Office Assistance area but that just confused me
more.
Thanks again for any help.

Thanks I appreciate the help, I'm going to give it a go right now.

"NetworkTrade" wrote:

* create a query that has all the fields you will want (including the drop
down) - give it a unique name. and be sure to open it so it is populated
with data.
* create a new form - based upon that query
* first add a list box - and when the listbox wizard launches be sure to
select the correct option that it selects the full record for the data
selected
* drag all the other fields from the field list onto your form

do a quick & dirty run - don't worry about it looking good....and then test
--
NTC


"25UinChatt" wrote:

I've got a feeling that the answer to this question is going to be so easy
that I'll end up smacking myself in the head for not thinking about it,
anyway, here's my question.

Lets say that I am creating a database that tracks the hours worked by
employees. What I'm trying to do is set up a data access page where I can
select the employee's name from a drop down list, and have it display the
hours the employee worked in a seperate text box for each day. As of right
now I can get the drop down list to display the names of all the people in my
table, but I can't get Access to pass the other information to the other text
boxes. Any help would be appreciated. I've read over all 30 articles
releating to this in the Office Assistance area but that just confused me
more.
Thanks again for any help.