Main Form ComboBox filtering data in Subform Datasheet view

A

AH

I have two subforms is my main form that I want to filter using a combobox,
but have not been able to achieve this.

When I change the data selected in the combobox, the subforms do not filter.
What do I need to do to make this work?
 
Top