Unanswered: Dynamically Setting Form Control Sources
I am keeping student records for my classes in Nanning, China. Yep, teaching English. For each student, I need to record marks and absences for 20 weeks ( for a total of 40 data fields). The basic table design is ugly (I simply use one record with 50 fields per student), but such is life.
What I want to do is to select through a combo box a period (such as week 6, and call a continuous form having student name, student number, a week 6 mark textbox and a week 6 absence textbox so that I can input data for that week. Easily done -- with 20 forms -- which I would like to avoid.
Is there any way to dynamically set the control source of the text boxes in a single form (i.e from a combo box in the proceeding forum which calls it)?
Nanning (still really hot)