print selected record on a subform

[Khalil Handal]

Hi,
I have a form with SubForm for customers. I select a customer (from Combo box) on the main form and the payments are shown on the subform (view: Datasheet View).



I need to add a command button to print an invoice (report already prepared) for a selected payment on the subform. How can I do that?

Khalil
Thanks in advance

[Welshgasman]

Pass in the CustomerID as the WHERE parameter when you open the report.

    stLinkCriteria = "[Ship] = '" & Me.cboShip.Value & "'"
    
    'DoCmd.CopyObject , stParam, acReport, stRptName
        
    If Me.ChkPreview Then
        DoCmd.OpenReport stRptName, iPreview, , stLinkCriteria, iDialog
    Else
        DoCmd.OpenReport stRptName, iPreview, , stLinkCriteria, iDialog
        DoCmd.OutputTo acOutputReport, stRptName, acFormatPDF, stFTPpath & stParam & ".pdf", False
        DoCmd.Close acReport, stRptName
    End If

[June7]

If you want report on only a single payment, then use PaymentID as filter criteria.

DoCmd.OpenReport "rptPayment", , , "PaymentID = " & Me.subformcontainername!PaymentID

[Khalil Handal]

Thank you.
I passed the customerId and the PaymentId as filter criteria

[Welshgasman]

Well as June mentioned, all you really needed was the PaymentID. That would be unique.
Good practice for combing more than one criteria though?