Print from a form to a report

[Toledo123]

I have a PO Form. After the user enters the information on the form I want to have a button that when clicked can send the information to the report where it can either be previewed or printed. Can someone tell me exactly how to do that?

My report is called POReport
My form is called frmPurchaseOrder
My Primary Key is NewPurchaseOrderID

Thanks for any help you can give me

 

[John Big Booty]

In the criteria of the query populating your report put the following;

Forms!frmPurchaseOrder!NewPurchaseOrderID

This will create a report specific to the current record on form frmPurchaseOrder.

 

[Toledo123]

Thank you for that

Don't I have to put some kind of button on my form?

 

[John Big Booty]

Yes you will need a button;

DoCmd.[URL="http://msdn.microsoft.com/en-us/library/office/bb238032%28v=office.12%29.aspx"]OpenReport[/URL] "YourReportName", acNormal

Will simply print the report for the current record if you use the schema I described in my previous post.

If you do not want to use the method described in my previous post try;

DoCmd.OpenReport "YourReportName", acNormal, "NewPurchaseOrderID = " & Me.NewPurchaseOrderID

Using this method there will be no need to adjust your existing query.

 

[Toledo123]

Thank you for that, it worked just great. Is there a way to send that filed to print preview and not directly to the printer?

 

[John Big Booty]

Use acViewPreview rather than acNormal check out other acView options here.