Transfer value of form text box to report text box

  • Thread starter Thread starter Scooter
  • Start date Start date
S

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.
 
What you show should work, but put it in the OnFormat event of the section
that contains the textbox on the report.
 
-----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
Click to expand...
control source put =[Forms]![form1]![textbox63]
 
Back
Top