Access Filter By Form Button. If you specify filter criteria on an or tab access will display records that match either the criteria on the look for tab or criteria on the or tab. A separate query sometimes called a filter query can refer to the controls on your dialog box to get its criteria.
The filter property of forms introduced in access 95 makes it easy to filter a form based on a control in the form. The filter query must include all tables in the record source of the form or report you are opening. A separate query sometimes called a filter query can refer to the controls on your dialog box to get its criteria.
The filter property of forms introduced in access 95 makes it easy to filter a form based on a control in the form.
To apply a filter automatically when a form is opened specify in the onopen event property setting of the form either a macro that uses the applyfilter action or an event procedure that uses the applyfilter method of the docmd object. The filter query must include all tables in the record source of the form or report you are opening. To apply a filter automatically when a form is opened specify in the onopen event property setting of the form either a macro that uses the applyfilter action or an event procedure that uses the applyfilter method of the docmd object. However the simple filter cannot be used if the field you wish to filter on is not in the form.
