Microsoft KB Archive/225928

= ACC2000: Filter By Form Is Disabled When ServerFilterbyForm Is Set to Yes =

Article ID: 225928

Article Last Modified on 7/14/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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.
 * 1) 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.

Additional query words: prb

Keywords: kbfix kbprb kbclientserver KB225928

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.