If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Populate List Box with Parameter
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 |
#2
|
|||
|
|||
Populate List Box with Parameter
"Channell" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|