Passing a Parameter from a Form to a Report

  • Thread starter Thread starter SteveH
  • Start date Start date
S

SteveH

I have an order form with an order id field. I also have an order report
based on the order id. I want to put a print button on the form that, when
clicked, generates the report based on that particular order id. How do I
pass that order id to the report? Any help would be greatly appreciated.
 
In criteria of the query that feeds the report use this --
[Forms]![YourFormName]![TextBoxName]

Substitute your actual form and text box names for [YourFormName] and
[TextBoxName].
 
That worked perfectly. Thank you!

KARL DEWEY said:
In criteria of the query that feeds the report use this --
[Forms]![YourFormName]![TextBoxName]

Substitute your actual form and text box names for [YourFormName] and
[TextBoxName].

--
Build a little, test a little.


SteveH said:
I have an order form with an order id field. I also have an order report
based on the order id. I want to put a print button on the form that, when
clicked, generates the report based on that particular order id. How do I
pass that order id to the report? Any help would be greatly appreciated.
Click to expand...
Click to expand...
 
Back
Top