Filter Subform ComboBox based on Master Form ComboBox selection (1 Viewer)

Hello,
I am using Access 2007, where I have a Master Detail Form. I want to filter the Subform Combobox Student Name list based on the Master Form Combo Box selection of Student Class. So how I complete this task, hope any one will help me to solve my issue.

Thanks,
Azam

in the query for the combox box you want to filter on (Student Name combo box) in the criteria for the student class Add something like:

[Forms]![YourMasterFormNameHere]![StudentClasscontrolNameHere.]

Click to expand...

Note: this will only work if the form you are pulling the filter from is open...