Forms to reports...Filtering(??)

[Guest]

I have a Orders Form and an Order Details Subform that join together to make
1 report listing all Orders and OrderDetails. Grouped by OrderID and
OrderDetail ID. The report is an order request form that is faxed to the
supplier.

What I want to happen is to put a control in my main form that when clicked
prints off the report for the single Order that is currently showing.

Do I use the main report and filter the Order Shown? (If so, How do I use a
filter as I've haven't used one yet)

And how would you recommend I do this? (possibly link the control on the
form to a reports form and select the type of report with / without filter?)

Any advice would be appreciated

 

[Al Campagna]

Woody,
Leave the form open when you run the report, and use a criteria in the query behind the
report to identify just the one record being displayed on the form.
Each Order should have a unique key field identifier that defines just that one record,
such as an OrderID.
In the report query, against the OrderID, use this example criteria (use your own
names)
= Forms!frmOrderForm!OrderID

The report will only return the data associated with that unique OrderID.