Printing a specific record in a report

[Mattine]

How do I print a specific order number, for example, in a report?

 

[bigpete994]

this works for me,

Private Sub Command30_Click()
Dim strReportName As String
Dim strCriteria As String

strReportName = "Orders"
strCriteria = "[OrderNo]='" & Me![OrderNo] & "'"
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
DoCmd.OpenReport strReportName, acViewPreview, , strCriteria
End Sub

 

[Mattine]

I am receiving a Data Type mismatch when I use this code, any ideas?

 

[bigpete994]

Hi Mattine
Sorry I can not think why you would get that it has worked on all my forms, search the forum it has more version of doing this i think OK

Pete X-)