Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Posts
    1

    Angry Unanswered: MS Access 2000 Filter by Form

    I am doing a search on an MS Access 2000 database using the 'Filter by Form'.


    I have created a serch button that when clicked it runs the command to filter by form.

    My problem is that everytime I run the search it retains the filter form retains the previous search criteria.

    I want the 'Filter by form' to be blank each time.

    Any ideas on how to do this.

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Try in the Form_Open event something like that

    me.FilterOn = true
    me.Filter=""

Posting Permissions

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