Transfer value of form text box to report text box

[Scooter]

I have a Form which has a textbox with no record source.
I enter a value into the text box. I then open a Report
without closing the Form. I have a textbox with no record
source on the Report. I want the Report's text box to be
equal to the Form's textbox when the Form opens. Maybe
something like the following in the OnOpen event of the
Report??? ...

me.textbox23 = forms!Form1.textbox63

I have forgotten how I did it a year or so ago.

 

[Ken Snell]

What you show should work, but put it in the OnFormat event of the section
that contains the textbox on the report.

 

[Guest]

-----Original Message-----
I have a Form which has a textbox with no record source.
I enter a value into the text box. I then open a Report
without closing the Form. I have a textbox with no record
source on the Report. I want the Report's text box to be
equal to the Form's textbox when the Form opens. Maybe
something like the following in the OnOpen event of the
Report??? ...

me.textbox23 = forms!Form1.textbox63

I have forgotten how I did it a year or so ago.
.
right click for properties on text box in report and in

control source put =[Forms]![form1]![textbox63]