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
 
Back
Top