Referencing subform on a page

[Jeff L]

What is the syntax for referencing a subform on a page
that's on a main form?

The main form is called frmMain, the page is called Child
and the subform is called frmChild

I've tried
Forms!frmmain.Child.frmChild
and get an 'Object doesn't support this property or
method' error

frmmain.Child.frmChild
and get an 'Object required' error

and a variety of other errors with different
configurations.

Any help?

Best Regards,
Jeff

 

[Allen Browne]

The tab control page does not come into the name.

Try:
Forms!frmMain!frmChild.Form!SomeTextBox

If the ".Form" bit is new, see:
Referring to Controls on a Subform
at:
http://members.iinet.net.au/~allenbrowne/casu-04.html

 

[Jeff L]

Excellent! And thanks for the link. I struggle at times
with the whole referencing objects / controls /
collections thing. Much appreciated.
Jeff