- Joined
- Jul 12, 2007
- Messages
- 45
- Reaction score
- 0
I have a dilema 
.
Despite many requests no-one answers....not even it can't be done! So here's hoping I get an answer, either way, doesn't matter.
I have a date field named [JobRequestDate] following that I have a combolist box [SchedDateTime]. The scheddatetime lists times from Mon to Sat. At the moment, when you pick a jobrequestdate (say a Thursday, date shown in short form) you have to scroll down the combo box to the 'Thur' times. (However, the problem is that so,etimes a wrong day is being picked and the Job goes to the wrong place (it's doesn't match the jobrequestdate field). I would like to be able to filter the [SchedDateTime] field to show ONLY the times for the day chosen in the [JobRequestDate] field.
The JobRequestDate (by the way has a pop-up calendar to choose the date).
Can this be done, if so how? What would be the code. and if not then is there another way for me to attain the thing that I seek.
Thankyou Databasers.
MCB
.Despite many requests no-one answers....not even it can't be done! So here's hoping I get an answer, either way, doesn't matter.
I have a date field named [JobRequestDate] following that I have a combolist box [SchedDateTime]. The scheddatetime lists times from Mon to Sat. At the moment, when you pick a jobrequestdate (say a Thursday, date shown in short form) you have to scroll down the combo box to the 'Thur' times. (However, the problem is that so,etimes a wrong day is being picked and the Job goes to the wrong place (it's doesn't match the jobrequestdate field). I would like to be able to filter the [SchedDateTime] field to show ONLY the times for the day chosen in the [JobRequestDate] field.
The JobRequestDate (by the way has a pop-up calendar to choose the date).
Can this be done, if so how? What would be the code. and if not then is there another way for me to attain the thing that I seek.
Thankyou Databasers.
MCB