Access Filter By Form Button. Select filter by form. Right click the show marlton button and select properties.
You can achieve the same result by changing the recordsource of the main form to an sql statement with an inner join to the table containing the field you wish to filter on. The look for tab will only display records that match all the criteria set there. If len txtsearch 0 then form name form filter me cmbsearch like me txtsearch form name form filteron true else form name form filter form name form filteron false end if.
Using this approach you filter the records in a form or report by setting the filtername argument of the openform or openreport method or action to the name of the filter query you create.
However the simple filter cannot be used if the field you wish to filter on is not in the form. Click the advanced filter options button. Select filter by form. The look for tab will only display records that match all the criteria set there.
