Passing a Form's control value to an unbount report's control

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

Guest

I use a form to print a report using the DoCmd.OpenReport.
The report has a control that is unbound so that a value has to be input
before it prints. I, however also need this value for the form for a later
operation. I can either get the value into the form first using inputbox and
then pass it on to the report, or visa versa. It doesn't matter to me as
long as I have access to the value entered.

You can think of it as a report that prints labels, and each label has not
only information of each record, but also all labels include the same text
that is input, somehow. And I need that text so I can use it in the form
that printed the labels.

Maybe this description is overkill, and I am sure the procedure is basic,
but I just don't know how to do it. Thanks in advance for any help.
 
If you have a form named Form1, with a text box named Text0, you can put
this into the Control Source of a text box on your report:
=[Forms].[Form1].[Text0]
 
G'day to you sir and thank you very much.

Allen Browne said:
If you have a form named Form1, with a text box named Text0, you can put
this into the Control Source of a text box on your report:
=[Forms].[Form1].[Text0]

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

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

Isaac said:
I use a form to print a report using the DoCmd.OpenReport.
The report has a control that is unbound so that a value has to be input
before it prints. I, however also need this value for the form for a
later
operation. I can either get the value into the form first using inputbox
and
then pass it on to the report, or visa versa. It doesn't matter to me as
long as I have access to the value entered.

You can think of it as a report that prints labels, and each label has not
only information of each record, but also all labels include the same text
that is input, somehow. And I need that text so I can use it in the form
that printed the labels.

Maybe this description is overkill, and I am sure the procedure is basic,
but I just don't know how to do it. Thanks in advance for any help.
Click to expand...
Click to expand...
 
Back
Top