Apply a filter when opening a form or report
When you use Visual Basic for Applications (VBA) code to open a form or report, you may want to specify which records to display. You can specify the records to display in the form or report in several ways. A common approach is to display a custom dialog box in which the user enters criteria for the underlying query of the form or report. To get the criteria, you refer to the controls in the dialog box. The following sections describe three ways you can use criteria entered in a custom dialog box to filter records.
Each type of filter performs the same basic function, but in a slightly different way. Advanced Filter/Sort option, found by clicking the advanced button, opens a window that actually has you building a query — selecting tables and fields to filter, setting up criteria for the filter to use while it’s finding specific records, that sort of thing.
Filters work in tables, forms, and queries. Although you can apply a filter to a report, filtering reports can be a daunting task. Of course, what you read here can be applied to that process, should you want to try it on your own. In addition, what you learn to apply to a table can be applied when you are working with queries and forms.
Filter By Form
You can tighten a search by using additional filters to weed out undesirable matches, but that takes a ton of extra effort. For an easier way to isolate a group of records according to the values in more than one field, try Filter by Form.
Filter by Form uses more than one criterion to sift through records. In some ways, it is like a simple query. It is so similar to a query that you can even save your Filter by Form criteria as a full-fledged query!
Please Watching My Video is Below
No comments:
Post a Comment