Filter Subform based on text box and combo boxes
Posted on 2013-06-06
I have found some answers on here, but I can't get them to work for my data. I have a "Documents" Form, with an unbound text box "Reference" and 4 unbound combo boxes "Doc Type", "Team" "Cupboard" and "Box". I then have a "DocumentsSubform" which displays the results of an "AllDocs" query.
I'd like the subform to be filtered by any combination of the reference field or the combo boxes. The "Reference" search also needs to be able to contain partial references of anything up to 12 alpha and numeric characters.
I don't want to use the after-update property for any of the boxes, I'd just like to trigger the query refresh from a "Search" button.
Can someone please help me write the code for the text box / combo box filter with the wildcards?