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

ID: Q225928


The information in this article applies to:

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.


Additional query words: prb


Keywords          : kbdta AccessCS 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbprb 

Last Reviewed: May 13, 1999