- Joined
- Jul 12, 2007
- Messages
- 45
- Reaction score
- 0
I have a form to a query that sorts serval fields to display the given data. No problem there 
. However I would like one of the fields to sort from a list depending on the date chosen. Hmm...
Ok here's an example: [JobSchedDate] (Picked from a pop-up calendar) chooses a date and it displays in the field. The second field [SchedDateTime], is a drop down list, listing the day time for the job (eg. Mon 8, Mon 9-12a, Mon 9-12b, Mon 10-1a, etc.) There are 16 time slots per day, making ther list very long. I would like to shorten this list by the [JobSchedDate] chosen. If the day is Monday then only the day-times are displayed for that day and not the entire list.
My knowledge isn't great in Access, I can set up a great form but as far as the coding...I'm at a loss
.
Please, I have posted a few times in this forum with no answer, some I have managed to remedy, so not. This is one I'd like to find an answer to.
Thankyou
MCB
. However I would like one of the fields to sort from a list depending on the date chosen. Hmm...Ok here's an example: [JobSchedDate] (Picked from a pop-up calendar) chooses a date and it displays in the field. The second field [SchedDateTime], is a drop down list, listing the day time for the job (eg. Mon 8, Mon 9-12a, Mon 9-12b, Mon 10-1a, etc.) There are 16 time slots per day, making ther list very long. I would like to shorten this list by the [JobSchedDate] chosen. If the day is Monday then only the day-times are displayed for that day and not the entire list.
My knowledge isn't great in Access, I can set up a great form but as far as the coding...I'm at a loss
.Please, I have posted a few times in this forum with no answer, some I have managed to remedy, so not. This is one I'd like to find an answer to.
Thankyou
MCB