Filter on subform

[Guest]

Hi

I want to apply a filter on a subform, but the name of the subform is a
string as i have a few subforms that i need to change the information on
using the apply filter. I have tried the following and prob realise there is
somethin really similar that will work but i can't get it to work.

Forms.Item("Frm_View Detailed").Form(formname).Filter =

Thanks for any responce in advance

Cheers

Danny

 

[Allen Browne]

Try something like this:
Forms![MyMain]![MySub].Form.Filter = "Surname = ""Smith"""

If you need to use string variables for the names:
strMain= "MyMain"
strSub = "MySub"
Forms(strMain).Controls(strSub).Form.Filter = ...