Generating a Report with only one record from a Form that has a subform

[bell]

Hi all,

I fairly new to Access so bare with me...

I am creating a data base that has two tables.
Table one is called Route Sheet and has a Primary key "Part Number"
Table two is called Operation Info and has two keys "Part Number" and "Operation Number"
The relationship is one to many --> "One" Part Number in Route Sheet to "Many" Part Numbers in Operation Info

I have a form called "Route Sheet Form" that has data entry stuff for all the fields in Route Sheet Table AND has a subform called "Operation Info subform" that displays all the fields in Operation Info Table for the particular part number selected.

I want to add a print button to the form to print only one record (the record that is currently selected) at a time. I created a Report from my "Route Sheet Form" and called it "Route Sheet Report"



I have looked over this website http://support.microsoft.com/kb/209560
I added a command button for printing to a report, and wrote the following for the On Click event

Private Sub Print_Report_Click()

    Dim strReportName As String
    Dim strCriteria As String
    
    strReportName = "Route Sheet Report"
    strCriteria = "[Part Number]=" & Me![Part Number]
    DoCmd.OpenReport strReportName, acViewPreview, strCriteria
    
End Sub

But the button still reports everything, not the single Part Number
Can anyone help me?

[ssanfu]

Looks like you are missing a comma. There should be two commas between "acViewPreview" and "strCriteria"
Try

DoCmd.OpenReport strReportName, acViewPreview, , strCriteria

[bell]

Looks like you are missing a comma. There should be two commas between "acViewPreview" and "strCriteria"
Try

DoCmd.OpenReport strReportName, acViewPreview, , strCriteria

Hi thanks for your reply,

I thought I had originally tried the code with the extra comma and I got an error so I took out the comma, but I just tried again with the extra comma and it now works...so I must have been doing something else wrong...

Thanks again