ACC2000: Filter By Form Is Disabled When ServerFilterbyForm Is Set to Yes (225928)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q225928
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access project (.adp).

SYMPTOMS

When you view a form in Form view, the Filter by Form feature may be disabled on the Form View toolbar.

CAUSE

In a Microsoft Access project, you can filter data at the server before it is retrieved from the database by using Server Filter By Form. When the ServerFilterByForm property is True, the Filter By Form feature is unavailable.

MORE INFORMATION

When you open a form with the ServerFilterByForm property set to Yes in Form view, the form will be displayed in a Server Filter By Form window. You can remove a filter by clearing all filter criteria in the Server Filter By Form window, and then clicking Apply Server Filter.

Steps to Reproduce Behavior

  1. Open the sample Access project NorthwindCS.adp.
  2. Open the Products form in Design view.
  3. On the Other tab of the Properties dialog box, set the ServerFilerByForm property to Yes.
  4. Save the changes and open the form in Form view.

    Note that the form opens in a Server Filter by Form window.
  5. On the Filter/Sort toolbar, click the Apply Server Filter button.

    Note that the form changes to Form view and the Filter by Form button is disabled because the feature is not available.
Modification Type:MinorLast Reviewed:7/14/2004
Keywords:KbClientServer kbfix kbprb KB225928
©2004 Microsoft Corporation. All rights reserved.