T
Tracker
I am trying to set up a database to track student and teacher
schedules for a new school. I want to have a main form with student
information on it. The subforms will then show the student schedule. I
tried making the subform appear like a calendar with text box headings
for days of the week and text box row headings for times of day. I
then used combo boxes for selecting class and room number for each day/
time, but I had trouble because the combo boxes all changed whenever I
selected a different value. I then attempted to add multiple subforms,
with the class name and room number in each box, and a separate
subform for each day/time. This seems too complicated and there has to
be a better way to format this. Any suggestions on the best way to go
about making this form? I am at a loss on how to proceed from here.
Thank you.
schedules for a new school. I want to have a main form with student
information on it. The subforms will then show the student schedule. I
tried making the subform appear like a calendar with text box headings
for days of the week and text box row headings for times of day. I
then used combo boxes for selecting class and room number for each day/
time, but I had trouble because the combo boxes all changed whenever I
selected a different value. I then attempted to add multiple subforms,
with the class name and room number in each box, and a separate
subform for each day/time. This seems too complicated and there has to
be a better way to format this. Any suggestions on the best way to go
about making this form? I am at a loss on how to proceed from here.
Thank you.