Reference Main-Report from SubReport

  • Thread starter Thread starter Larry Larsen
  • Start date Start date
L

Larry Larsen

Hi
What would the syntax be to reference a control(text1)on the main
report, and place the value into a text box on a sub report (text2).
Main Report = Report1
Main Report Text box = Text1
Sub Report = subReport1
sub Report Text Box = Text2
Any help many thanks.
 
Me!txtMyBox = Me.Parent!txtItsBox should do it.

where, txtMyBox is the name of the text box in the report embedded in the
subreport control and txtItsBox is the name of the text box in the main
report.
 
Larry said:
What would the syntax be to reference a control(text1)on the main
report, and place the value into a text box on a sub report (text2).
Main Report = Report1
Main Report Text box = Text1
Sub Report = subReport1
sub Report Text Box = Text2
Click to expand...

Use an expression in the subreport's text box:

=Parent.Text1
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding values from sub reports in the main report 8
This report is killing me slowly. 1
Calculating values from 2 subreports.................. 1
Using Subreports to create a Main Report 7
Filtering subreports on main report 0
Select subreports for Main Report - HELP! 4
calculations 2
Calculate a sum of subreports in main report 1

Back
Top