Populate List Box with Parameter

[Channell]

Hello,

I have a Parameter Query that contains a couple tales and sub query. Under
the criteria section of the field "WorkDate", it goes as follows:
[Forms]![fEMPLOYEEVOLUMECREATOR]![Datetxt]

I have plenty of forms working with a parameter like this, but I need some
help with the following:

After I type in a date in Datetxt, I receive all the records I need.
However, I have a ListBox on this form that I want Populated with all the
employees that worked this particular day. If I choose a different date, I
need the list box to update and populate with the employees that worked this
particular date. Thank you for your help! I very much appreciate you help!

Query:
[DailyInfoID]
[WorkDate]
[EmployeeName]
[Other information and so forth....]

-Scott Channell

 

[Channell]

Hello,

I have a Parameter Query that contains a couple tales and sub query. Under
the criteria section of the field "WorkDate", it goes as follows:
[Forms]![fEMPLOYEEVOLUMECREATOR]![Datetxt]

I have plenty of forms working with a parameter like this, but I need some
help with the following:

After I type in a date in Datetxt, I receive all the records I need.
However, I have a ListBox on this form that I want Populated with all the
employees that worked this particular day. If I choose a different date, I
need the list box to update and populate with the employees that worked this
particular date. Thank you for your help! I very much appreciate you help!

Query:
[DailyInfoID]
[WorkDate]
[EmployeeName]
[Other information and so forth....]

-Scott Channell

After Playing with this for a bit, I got it. I feel bad for asking
questions and then figuring out the questions before anyone has a chance to
answer. It is almost as if I am wasting people's time, and I am sorry for
that. However, for those who may be interested, the row source of the
listbox is as follows:

SELECT qVOLUMECREATOR.EmployeeName, qVOLUMECREATOR.Workdate
FROM qVOLUMECREATOR
ORDER BY qVOLUMECREATOR.EmployeeName;

I hope this helps someone!

-Scott Channell