H
Hilarys
I need help with my student's tutorial booking form.
I have a main form [Tutorial_Sessions] where you select a date from a
Calandar control and an unbound control [WkDayNo] using a Datepart expression
to give me a number for the day of the week.
I then have a continuous subform with the names of the pupils and a combo
box [TimeCmb] listing the available days and times from the
[Tutorial_Times_Qry] which includes a field where the days of the week are
numbered 1-7, Sun - Sat.
I want the subform's combo box to just show the available times on an eg
Monday if the date on the main form is a Monday. I have tried lots of
different ways but just can't get it to work...help, please!
Hilarys
I have a main form [Tutorial_Sessions] where you select a date from a
Calandar control and an unbound control [WkDayNo] using a Datepart expression
to give me a number for the day of the week.
I then have a continuous subform with the names of the pupils and a combo
box [TimeCmb] listing the available days and times from the
[Tutorial_Times_Qry] which includes a field where the days of the week are
numbered 1-7, Sun - Sat.
I want the subform's combo box to just show the available times on an eg
Monday if the date on the main form is a Monday. I have tried lots of
different ways but just can't get it to work...help, please!
Hilarys