Filter a Subform

[campo88]

On a form I want to filter a subform according to the value chosen on a combo box.


My subform is made from a query and in this query I have the below criteria for one of the fields.
Like [forms]![Results_Form].[combo49] & "*"


I also have the following code, so it requeries:
Private Sub Combo49_AfterUpdate()
Me.Requery
End Sub

The filtering seems to work. However, the problem is that I do not know how to reset a filter so that there is no filter and therefore all the data is showing on my subform. Please help!

 

[llkhoutx]

On the event the subform filter is is to be removed, simply set the filter to Null, e.g.

Forms!Mainform!subform.filter = Null

 

[McSwifty]

You can also try playing with the command FilterOn and try setting to true false as well.
in conjunction they work well.

 

[campo88]

I am getting a run-time error "438" when using that code

"Object does not support this property or method"

??

 

[llkhoutx]

forms!mainform!subform.filteron = true

You can leave this property on and with the filter property equal null, all records will be returned.