Refer to a control on a sub report

[Guest]

I cannot get the data from my subreport to my main report. I have looked
that the posts and tried them and at http://allenbrowne.com/casu-18.html but
I still get #NAME.

So here is my information and maybe someone can tell me what I am missing.

I have a main report with 5 subreports. The one I want data from is
the 5th one (does that make a difference?)

Properties of the Report (5):
Name: rptSContribFactor
Source Object: Report.rptSContribFactor

Properties of the TextBox on rptSContribFactor
Name: txtFRN
Control Source: FixRemovedNada

MainReport Info:
Text box name: txtTEST
Control Source: =[rptSContribFactor].[Report]![txtFRN]

I was getting a paramater input when running it but now with the above
information I only get #Name?

Any ideas?

tia

Vanya

 

[Guest]

Try

=SubReportControlName.Report.txtFRN

SubReportControlName need to be the name of the control and not the name of
the report in that sub report, unless they are the same

 

[Guest]

Ofer,

Thanks. However if I put in my textbox on the main form
=SubReportControlName.Report.txtFRN
I get a parameter dialog box asking for the value of "SubReportControlName"

txtFRN is the subreport control name. Then I change the name of my sub report
Now it is:
Name: rptSCF
Source Object: Report.rptSContribFactor

If I put in: =txtFRN.report.rptSCF, it asks for the value of txtfrn. Even
if I give it a good value, it displays #Name?

Okie dokie. I try =rptSCF.report.txtFRN no parameter dialog box but
for the value on the report I still get #Name?

Any ideas on what I am goofing up?

Try

=SubReportControlName.Report.txtFRN

SubReportControlName need to be the name of the control and not the name of
the report in that sub report, unless they are the same

--
Good Luck
BS"D

I cannot get the data from my subreport to my main report. I have looked
that the posts and tried them and at http://allenbrowne.com/casu-18.html but
I still get #NAME.

So here is my information and maybe someone can tell me what I am missing.

I have a main report with 5 subreports. The one I want data from is
the 5th one (does that make a difference?)

Properties of the Report (5):
Name: rptSContribFactor
Source Object: Report.rptSContribFactor

Properties of the TextBox on rptSContribFactor
Name: txtFRN
Control Source: FixRemovedNada

MainReport Info:
Text box name: txtTEST
Control Source: =[rptSContribFactor].[Report]![txtFRN]

I was getting a paramater input when running it but now with the above
information I only get #Name?

Any ideas?

tia

Vanya