J
JimN
Vocational students are selected from a combo box, SelectStudentName, in a
form, SelectStudent, and the courses in which they are registered are shown
in a subform, CourseSubform. The students have one course per semester but
can be paying on courses for 2 semesters, so the subform, CourseSubform can
show 2 records for a student. The PaymentsSubform allows entry of the current
payment. A combo box, Course Number, in the PaymentsSubform must have the
student’s courses listed so the user can select the appropriate course for
the current payment. When a different student is selected in the
SelectStudentName form, the PaymentsSubform, Course Number combo box list is
not updated and does not show the newly select student's courses. The
SelectStudentName student selection combo box event procedure, after update,
is: Forms!SelectStudent!PaymentsSubform.Form!CourseNum.Rowsource="SELECT
QueryCurrentCourses.CourseNum, QueryCurrentCourses.StudentID FROM
QueryCurrentCourses WHERE QueryCurrentCourses.StudentID =
Forms!SelectStudent!StudentID". (QueryCurrentCourses is the control Source
for the CourseSubform and all forms and subforms use StudentID for their
relationships.) How can the Combo box CourseNum.RowSource be updated?
form, SelectStudent, and the courses in which they are registered are shown
in a subform, CourseSubform. The students have one course per semester but
can be paying on courses for 2 semesters, so the subform, CourseSubform can
show 2 records for a student. The PaymentsSubform allows entry of the current
payment. A combo box, Course Number, in the PaymentsSubform must have the
student’s courses listed so the user can select the appropriate course for
the current payment. When a different student is selected in the
SelectStudentName form, the PaymentsSubform, Course Number combo box list is
not updated and does not show the newly select student's courses. The
SelectStudentName student selection combo box event procedure, after update,
is: Forms!SelectStudent!PaymentsSubform.Form!CourseNum.Rowsource="SELECT
QueryCurrentCourses.CourseNum, QueryCurrentCourses.StudentID FROM
QueryCurrentCourses WHERE QueryCurrentCourses.StudentID =
Forms!SelectStudent!StudentID". (QueryCurrentCourses is the control Source
for the CourseSubform and all forms and subforms use StudentID for their
relationships.) How can the Combo box CourseNum.RowSource be updated?