- Joined
- Jul 12, 2007
- Messages
- 45
- Reaction score
- 0
Greetings Databasers!
I have a date box (from pop-up) that the user can choose to add date to a field [ScheduleDate]. The second box is [SchedTime], with a list of day times e.g. Mon 8, Mon 9-12a, Mon 9-12b....etc thru to Sat. At the moment you have to scroll down the list to find the right day then choose the time, I would like for this combo box to sort itself based on the date chosen. So if if the date chosen falls on a Tuesday, only the Tue times display in the combo box, I have no idea on how this can be done, and where the coding is written.
Second, I need the [SchedTime] to be prevented in duplication for that day. Meaning if the time picked for a schedule it cannot be chosen again for that day.
Any help in these matters will be appreciated.
Thanks in advance
MCB
I have a date box (from pop-up) that the user can choose to add date to a field [ScheduleDate]. The second box is [SchedTime], with a list of day times e.g. Mon 8, Mon 9-12a, Mon 9-12b....etc thru to Sat. At the moment you have to scroll down the list to find the right day then choose the time, I would like for this combo box to sort itself based on the date chosen. So if if the date chosen falls on a Tuesday, only the Tue times display in the combo box, I have no idea on how this can be done, and where the coding is written.
Second, I need the [SchedTime] to be prevented in duplication for that day. Meaning if the time picked for a schedule it cannot be chosen again for that day.
Any help in these matters will be appreciated.
Thanks in advance
MCB