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
 
Top