Print Document direct from the form

[ahafeez]

Hello

I am finding a problem in code to generate an output direct from Access Form. I am explaining my problem with the help of example

I designed an invoice form on the MS Access and designed this document in MS Access Report designer and Crystal Report as well. What i need to do if i am on MS Access form and i am on invoice # 100 when i press "Print" button then from report invoice # 100 will be print.

Kindly send me a code which will use in print button.

Hafeez

[PEB]

You need to use:
1. docmd.openreport command for more info see help in Access about it

2. You need to change the SQL passed on the report! You have to introduce an filter that shows only the current record! This filter you can pass it bythe command docmd.openreport

The code as well as U do Copy Paste I can't do it without information about your Tables, queries, forms and reports that U use!

U have only to see the use of docmd.openreport as Macro or Code as U want!

[MMcCarthy]

You need to set criteria for opening the report same as with forms.

Private Sub butPrint_Click()
Dim stDocName As String
Dim stLinkCriteria As String
 
    stDocName = "ReportName"
    stLinkCriteria = "[InvoiceNo]=" & Me.[InvoiceNo]
    DoCmd.OpenReport stDocName, acViewNormal, , stLinkCriteria
 
End Sub
 

Hello

I am finding a problem in code to generate an output direct from Access Form. I am explaining my problem with the help of example

I designed an invoice form on the MS Access and designed this document in MS Access Report designer and Crystal Report as well. What i need to do if i am on MS Access form and i am on invoice # 100 when i press "Print" button then from report invoice # 100 will be print.

Kindly send me a code which will use in print button.

Hafeez