Access Filter By Form Button. Select filter by form. On error goto errhandler marked with for now so i can use the access debug button dim txtsearch as string.
On error goto errhandler marked with for now so i can use the access debug button dim txtsearch as string. Select the characters that you want on the home tab in the sort filter group click selection and then click the filter you want to apply. The filter query must include all tables in the record source of the form or report you are opening.
The filter query must include all tables in the record source of the form or report you are opening.
This filter is useful when you want to filter on several fields in a form or datasheet or if you are trying to find a specific record. In the filter by form window you can specify your filter criteria by using the two tabs at the bottom of the window. The filter property of forms introduced in access 95 makes it easy to filter a form based on a control in the form. A separate query sometimes called a filter query can refer to the controls on your dialog box to get its criteria.
