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