Hello People, my first time here.

I cannot be able to filter a subform using VBA? I can do it no problem on a single form.
But when I try forms
("frmMainForm")("frmSubFormDataSh").filter = "[x] = 'whatever'"
I get Run time Error 438 Object doesn't support this property or method.

Am I doing this the wrong way or am I right in thinking this may not be possible?

I need to filter the subform from the header in the main form. Should this be possible???

Thank you for your help

julian