Label Field In Header


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
 
Ad

Advertisements

A

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.

Eric Chajmovic said:
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top