I have a subform that I am attempting to set a filter value for.
However access claims that the subform does not have a property or
method called filter. I know its not a misspelled name or anything as
I can execute a refresh on the sub form:

Forms!frm_BUDATA!Contacts.Requery

However, the statement:

Forms!frm_BUDATA!Contacts.Filter = sFilter

Generates an error. Can anyone shed some light on this?

Thanks!

I reference the subform from within my form. I can not get it to
reference properly the way you do.

This is how it looks for me :

Me.subFormName.Form.Filter = "string"
Me.subFormName.Form.FilterOn = true

What is 'Contacts'?

I *can* reference the form globally by using an _ where you have the
first !. I would use "Form_frmBUDATA". Hrm...

-- Andrew Backer / abacker .@. comcast .dot. net

yagfxgeek wrote: