Passing a Parameter from a Form to a Report

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.
 
K

KARL DEWEY

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].
 
S

SteveH

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.
 

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