利用表單篩選搜尋

  1. 開啟包含資料庫欄位的表單文件。

    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 icon to turn off the design mode.

    Icon Design Mode

    Design Mode On/Off

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

    Icon Form Navigator

    Form Navigator

  4. 在一個或數個欄位中輸入篩選條件。注意,如果您在數個欄位中輸入篩選條件,則所有輸入的條件都必須符合(布林 AND)。

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

如果您按一下 [表單篩選] 工具列上的套用以表單為基礎的篩選圖示,則將會套用篩選。 您會看到 [表單瀏覽] 工具列,並可瀏覽找到的記錄。

如果您在 [表單篩選] 工具列上的 [關閉] 按鈕上按一下,則表單會不使用篩選而直接顯示。

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

Icon Apply Filter

Apply Filter

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

Icon Reset Filter/Sort

Reset Filter/Sort

Please support us!