Label Field In Header

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

How can I have the label field (or a text field) change on the 'On Open' event of a report, and have the text taken from a form that opened the report

Thanks

Eric
 
Set the Control Source of the text box to something like this:
=[Forms]![MyForm]![MyTextbox]

If you want to do it with code, you could use an unbound text box, and
assign a value in the Format event of the section containing the text box.
(The report's Open event is too early to assign a value.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Eric Chajmovic said:
Hello,

How can I have the label field (or a text field) change on the 'On Open'
Click to expand...
event of a report, and have the text taken from a form that opened the
report?
 
Back
Top