Links are not active on this page.
 How to: Filter Records in Tables

You can specify that only certain records display in browse windows by setting a data filter.

Caution noteCaution

If you restrict access to all the fields in a table, you might not be able to open the table in a browse window.

To filter records in a browse window

  1. Open the table in a browse window.

  2. On the Table menu, click Properties to open the Work Area Properties dialog box.

  3. In the Data filter box, type the filter expression you want. To build an expression, click the ellipsis (...) button.

  4. Click OK.

    The browse window displays only those records that meet the filter expression.

For example, the following filter expression displays on those records in a Customer table where the Country field is set to "USA":

 CopyCode imageCopy Code
Customer.Country = "USA"

See Also