Creating a purchase order report

[Diggar]

I have a data base with about 4 different tables.
1. Cust info
2. Supplier info
3. Order History
4. Order details.

Order history and details are on one form with details being the
subform. This allows a 1 to many with the details.

This is all working fine. A person can input data into the main part
of the form and then go to the subform and add the details.

What I would like to do is create a button that the user can click on
that would print a report setup as a Purchase Order with information
on it from the main form and the detail form, so I can send that to my
supplier.

1.) I need it to print the current record that was just input.
2.) I need it to be able to re-print any record in the event the
original PO is lost.

I know this isn't very difficult to do but for some reason I cannot
get it started.

Do I
1.) Use a query to base the information?
2.) Then create a report based on that query and lay it out as I want it?
3.) How do I get it to ask for a specific transaction in the event I
want to re-print later.

4.)Are these two seperate items?

I hope I have been clear. Please feel free to ask any questions.

Thanks for the help.

[MMcCarthy]

1.) Use a query to base the information? Yes
2.) Then create a report based on that query and lay it out as I want it? Yes
3.) How do I get it to ask for a specific transaction in the event I
want to re-print later.

In the Report Open Code you have to set criteria based on the unique ID of the Order (I'm using OrderID as the example)

DoCmd.OpenReport "Report Name", acViewPreview, ,"[OrderID]=" & Me!OrderID

This will print preview the record corresponding to the current OrderID on the form.

4.)Are these two seperate items? No

Mary