Passing values to a report

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

Guest

Does anyone know which is the best way to pass a value from an unbound field within a form to an unbound field within a report? Thanks in advance.
 
Set the Control Source of a text box on your report to something like this:
=Forms![NameOfYourFormHere]![NameOfYourTextboxHere]

Explanation:
Unlike forms, there is a very small window when you can set the value on the
report. Essentially it is only after the report's Open event has fired, and
up to the time the Print event for that section occurs.

To achieve that, you have to get the report to read the form instead of the
other way around.

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

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

Jedster said:
Does anyone know which is the best way to pass a value from an unbound
Click to expand...
field within a form to an unbound field within a report? Thanks in advance.
 
Back
Top