Refer to Form and Subform controls

[Leo_Polla_Psemata]

I have a form , subform

I want to use this and open a query
[Forms]![Mainform]![RecordSource]

But the recordsource is in the subform

I try to find the correct syntax but my attempts were not successful.

I cheched in here as well, nothing
http://access.mvps.org/access/forms/frm0031.htm

Could someone type it for me ?

 

[Ranman256]

you dont need the path to the subform data.
the recordsource on the subform is in the subform , so just build a query to that table listed.
Is that what you want?
or
to reference a text box (or other control) use the PICKER. It shows you all the items there.
but the path is usu: forms!mainform!subform!form!txtBox

 

[apr pillai]

forms!mainform!subform!form!txtBox

correction:

 forms!mainform!subform.form!txtBox

 

[Leo_Polla_Psemata]

 forms!mainform!subform.form!txtBox

Dear Apr
You are absolutely correct, the link is also correct
http://access.mvps.org/access/forms/frm0031.htm

We should ALWAYS inspect that the form subform names are typed properly
and that the form link to subform, uses the same name, if not, you may end up awake all night long, asking why and what's the meaning of life and so on. . .