Subform Reference

[bbulla]

Hi,

I have a form (frmSWL) with a subform container on it (subfrom1) which has a source object called frmSite. How do I reference frmSite from another form so I can apply a filter to it??

I am trying:

forms!frmSWL!frmSite.Filter = "......."

, but it is not working.

Thanks,

 

[boblarson]

Forms!frmSWL.subform1.Form.Filter

The .Form. part needs to be there as written (you don't substitute anything for it). You need to reference the subform CONTAINER (control on main form that houses the subform) and not the subform name, unless the subform name is the same as the subform container.

 

[bbulla]

Excellent! Thanks. This was driving me nuts. I never would have even guessed the .Form part. Works perfectly now.

 

[boblarson]

If you want more about why you use that, see my "quick tutorial" on my website:

http://www.btabdevelopment.com/main...rhowtoreferencesubforms/tabid/76/Default.aspx