Label Field In Header

[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

 

[Allen Browne]

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.

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?