|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 22nd, 2009, 03:33 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
Passing a Parameter from a Form to a Report
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. 
|
|
#2
July 22nd, 2009, 03:46 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Passing a Parameter from a Form to a Report
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" wrote: 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.
|
|
#3
July 22nd, 2009, 04:00 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Passing a Parameter from a Form to a Report
That worked perfectly. Thank you!
"KARL DEWEY" wrote: 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" wrote: 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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
