W
WarriorMCB
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 sometimes 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
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 sometimes 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