Filtering on sub form

[4321z]

Trying to apply a filter to a sub form - thats based on a query, by using the Docmd.applyfilter
but access thinks i'm trying to apply the filter to the parent form which is not linked to any query or table and tells me of this,

any suggestions?

 

[RoyVidar]

You could try to use the .filter and .filteron properties of the subform.

For instance something like this from the main form:

[tt]Me!SubControlName.Form.Filter = "yourfilter"
Me!SubControlName.Form.FilterOn = True [/tt]

SubControlName - the subform control name, which might differ from the name of the subform as viewed in the database window, replace "yourfilter" with your current filter.

Roy-Vidar