Thanks for posting so quickly Alex, but that doesn't seem to work. Maybe I can explain further.
The first form (main) has the insturctors name, phone, deparmtnet, and other location info. This information comes from a instructor table, that has a relationship with the class table (the classes they teach). The main form also has a combo box with a list of semester codes that is drawn from a semester code table.
The subform has a list of classes taught by each teacher. When the main form shows the instructor, the subform shows all the classes the instructor is teaching. I have added a Semester code like the main combo box in the subform and the class table so that it can be selected for the semester it is being taught. Everytime the record is changed to show the new insturctor, the subform changes to reflect the classes. This is done through a query of course.
The problem here is that when I select the combo box in the main form, the semester code, it doesn't show just the Classes taught by the semester code in the class table for that insturctor, and that is where my dilemna is. I tried out that link you sent me, but it doesn't seem to want to work for me. Maybe there is another way, or I might be doinng something wrong. Any help you can give would be great.
