I have created a school database in Access 2003. The main form allows you to view information on a particular student. The name of this form is MainStudentForm". I use the tabcontrol feature to display different information on the student. There is a tab control tab to show the courses they are enrolled in. The courses are displayed in a subform called "Subform1".
I would like to use a combo box on the main form to select a semester. After choosing a semester in the combo box, the subform is filtered to show courses for just that semester.

How do I do this?

-Mike