I have a form "PartsAndInvoic es that has all the parts in the database listed in split form view. I want the user to use Access 2007's filter section on the ribbon to choose mutiple filters. Me.Filter may equal ([Lookup_cboDNRCI D].[DNRCNUM]="dnr1940"). I tried pass ing me.filter to the report but get all the records in the report not the custom filtered set.
Private Sub cmdPartsNInvoic eReport_Click()
Dim strFilter...