Open correct report

[foxtet]

I have a billing form. After input necessary data I want invoice to be created. When I press create invoice button it displays different invoice.

how to handle this?

foxtet

 

[JHB]

How do you open the report, code or??
If code then show it.

 

[foxtet]

I use the following command. it displays all records.but I want display specific record.
Private Sub cmdInv_Click()

Dim strReportname As String
Dim strCriteria As String

strReportname = "rptInvoice"
strCriteria = "[InvNo] = & Me.InvNo"

DoCmd.OpenReport strReportname, acViewPreview, strCriteria

End Sub

foxtet

 

[Minty]

Assuming InvNo is a number you need

strCriteria = "[InvNo] = " & Me.InvNo