Tab Control subform recordsource

[Nat]

I am using a tab control form with subforms on the pages of the tab control.
I am trying to change the recordsource of the subform based on changing of a
combo box on the main form. When I refer to the recordsource of the subform
on the tab control page, I am getting 'Object doesn't support this property
or method'.

I am also getting the same message when trying to use the recordsetclone
method on the subform. Are these methods unavailable when using tab-controls
and sub-forms?

I am using the following format to refer to the recordsource:

forms!frmviewproject!tabctl24.pages("Parent
Agreement").controls!sfrmProjHeader.recordsource = ......

where frmviewproject is the main form, tabctl24 is the tab control with
Parent Agreement as the page and sfrmprojheader is the subform that exists on
that page.

Thanks!

 

[Brendan Reynolds]

Try ...

forms!frmviewproject!tabctl24.pages("Parent
Agreement").controls!sfrmProjHeader.Form.recordsource = ......

 

[Nat]

Thank you.....it worked. Appreciate the quick response.