I have a filter that works fine with one element but when I add a second it doesn't work.
right now I have a search text box in a main form that filters a subform based on the textbox in the subform called "SupplierCode". I also have a textbox called "SupplierName" and would like to apply the filter to both textboxes...filtering anything that contains either part of the "SupplierCode" OR the "SupplierName".
here is the simple filter that works:
Me.sbfrmEntitySearchSupplier.Form.Filter = "[SupplierCode] LIKE '*" & Me.search0 & "*'"
Me.sbfrmEntitySearchSupplier.Form.FilterOn = True
how would I do this?