\<bookmark_value\>form filters\</bookmark_value\>\<bookmark_value\>databases;form filters\</bookmark_value\>\<bookmark_value\>searching; form filters\</bookmark_value\>\<bookmark_value\>removing;form filters\</bookmark_value\>\<bookmark_value\>filtering; data in forms\</bookmark_value\>\<bookmark_value\>data;filtering in forms\</bookmark_value\>\<bookmark_value\>forms; filtering data\</bookmark_value\>

Searching With a Form Filter

  1. Open a form document that contains database fields.

    As an example, open an empty text document and press + Shift + F4 keys. Open the bibliography database table biblio in the data source view. While pressing Shift+, drag a few column headers into the document so that the form fields are created.

  2. On the Form Controls toolbar, click the Design Mode On/Off iconIcon to turn off the design mode.

  3. On the Form Navigation toolbar, click the Form-Based Filters iconIcon. The current document is displayed with its form controls as an empty edit mask. The Form Filter toolbar appears.

  4. Enter the filter conditions into one or several fields. Note that if you enter filter conditions into several fields, all of the entered conditions must match (Boolean AND).

More information about wildcards and operators can be found in Query Design.

If you click the Apply Form-Based Filter icon on the Form Filter toolbar, the filter will be applied. You see the Form Navigation toolbar and can browse through the found records.

If you click on the Close button on the Form Filter toolbar, the form is displayed without a filter.

Click the Apply Filter iconIcon on the Form Navigation toolbar to change to the filtered view.

The filter that has been set can be removed by clicking Reset Filter/Sort iconIcon.

Using the Filter Navigator

Searching Tables and Form Documents

Please support us!