Print a report from a query

[sc5502]

Background:
Front end: MS Access 2010/VBA
Back end: MS SQL Server 2008

I have a MS Access database that has a report and it works fine. The report lists evaluations on every supplier
in the database. I have a form/subform that displays every supplier in the database. Is there a way to select a
supplier and print just that supplier's evaluation?

Thank you in advance.

[jforbes]

The following code is something I use to Print a Report and limit the Report by Primary Key to the Primary Key of the Current Record shown on the Form:

Private Sub cmdPrintTag_Click()
    Dim sJobNumber As String
    sJobNumber = Nz(Me!JobNumber, "")
    If Len(sJobNumber) > 0 Then DoCmd.OpenReport "JobTag", acViewNormal, , "JobNumber='" & sJobNumber & "'"
End Sub