Connect a subform to a datasheet subform
Posted on 2001-08-30
I am using Access 97
I have a form called ?student & courses specific form? and a subform called ?student & course subform? (yes there are gaps!).
The main form shows students personal details and the subform shows the courses they are doing this year.
The subform has a field called ?courseid?.
I can record the courses they are doing using the main form.
I can also record the course(s) that students are doing through another form called ?courses & participants form? which has a couple of subforms, one of which (called ?Q vacancy answer form?) calculates the number of vacancies in a course from the maximum set and the number of enrolments in that class. This form works fine.
Although I can enrol students in a class through the ?student & courses specific form? form this doesn?t show the number of places left in a class. I don?t want to accept students in a class that is full.
I tried attaching the form called ?Q vacancy answer form? form as a subform on the ?student & courses specific form? form but Access won?t allow a subform on another form where that form (ie ?student & course subform?) is displayed as a datasheet. I do need it shown as a datasheet.
How do I get the ?student & courses specific form? to show me how many vacancies are in a class before I enrol a student?