Filter By Form on Subforms
Filter By Form on Subforms
(OP)
I have a form with two subforms on it. When I go to search using filter by form on the subform. I get the result of all the record not the ones I want to searching for.
Can you help?
Thanks
Can you help?
Thanks
RE: Filter By Form on Subforms
I have been able to accomplish this with a separate unbound search form called from the main form.
With some coding you can set the search form to search both a main form as well as a subform.
The trick is creating some SQL that is called when you search any of the sub form fields. Then the SQL is applied to the record source and then if you have any fields from the main fomr that you included in the search a filter is applied to the main form.