Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2007
    Columbia SC

    Unanswered: Cannot apply Filter on one or more fields specified in the Filter property.

    I have adp application and sql server at backend.Now I m creating and report upon the user selection by the combo boxes.
    But report doesnt filter records according to the values of combo boxex. and it gives an error
    "Cannot apply Filter on one or more fields specified in the Filter property."

    I have also tried to take out everything from the filter property of report but doesnt work.
    Everything i m taking input from the user exist in the database.

    Where could be the problem in this scenario.


  2. #2
    Join Date
    Dec 2004
    Madison, WI
    Off-hand with the error you're describing (without witnessing it first hand), I'd guess that it's giving you an error because the filter cannot be applied to the recordset you're returning (ie. for example you are trying to filter on 1 record all of which does not meet the criteria you've specified) or there is something wrong with the way you are trying to apply the filter (ie. perhaps you're trying to apply a filter to a field which doesn't exist.) But that's just guessing without seeing it. Can you try applying the filter to a different field to test it?
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts