Reference Main-Report from SubReport

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.
 
L

Larry Linson

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.
 
M

Marshall Barton

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
 

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

This report is killing me slowly. 1
Get totals from sub report to main report 1
Using Subreports to create a Main Report 7
calculations 2
Conditional display of subreport 6
Adding values from sub reports in the main report 8
Calculate a sum of subreports in main report 1
Main Report Header is on SubReport 4

Top