Add something like this to the After Update event of the combo (I assume that
is where you are filtering the main form)

Me.MySubFormControl.Form.Filter = 'put the filtering criteria here
Me.MySubFormControl.Form.FilterOn = True

There is a bug to be aware of when filtering both the form and the subform.

Go to this site http://allenbrowne.com/Access2007.html#Bugs
Click on Whats Fixed
In the last entry in the table (Filters), click on Filter Bugs
Read item 1.

"eschlep via AccessMonster.com" wrote:

I have a combo box in a form header that filters records in the detail
section. I want that combo box to also filter a subform that is located in
the footer section of the form. The subform always displays all the records,
could someone help me to get the subform to filter the records by using the
combo box in the header of the main form.

Thanks

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200612/1