Data from form to report.

[2ippy]

I'm trying to use a button to clear and then filter a report, with 2 variables.

CustomerID and ItemID

And then print, from a form i have.

Private Sub Command86_Click()
    Dim stDocName As String
    Dim SupID
    Dim SupID2

    SupID = Me![CustomerID]
    SupID2 = Me![ItemID]
    stDocName = "Receipt"
    DoCmd.OpenReport stDocName, , , , acFormAdd
    Reports![Receipt]!CustomerID = SupID
    Reports![Receipt]!ItemID = SupID2

Tried to use a similar code used from a form to form, but I'm quite useless

 

[grnzbra]

You need to set the report's filter property to something like:
"CustomerID = '" & SupID & "' and ItemID = '" &SupID2 & "'"
If these IDs are numeric instead of text, eliminate the single quotes.

 

[2ippy]

it's ok the code i was using is crap, i've replaced it with sommat really short