Filtering sub report

[eyalco]

I have a report (receipt) which i filter by customer_id but the receipt items, which are placed in a subreport, are not filtered so every time I want to print, I get the customer I want but the sub report shows all items from all customers.

How do I filter the sub report as well? (the filter I'm using is

strCriteria = "[receipt_no]= " & Me.[RECEIPT_NO]

)

Thanks.

 

[boblarson]

Actually if you link the Master / Child links to the CustomerID and Receipt_NO then you won't have to filter, it will do it for you.

 

[eyalco]

Thanks Bob.
Working.

 

[boblarson]

Glad we could help