Results 1 to 2 of 2
  1. #1
    Karyn-2000 is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2005
    Dallas, TX

    Automatic Filtering when Opening form

    Is there a way to set up a form so that it applies a filter automatically when the form is opened so that a user only sees the filtered records without having to press the filter toggle or filter every time?

  2. #2
    StepUP is offline Advanced Beginner
    Windows 7 64bit Access 2000
    Join Date
    Dec 2005
    On the "Open" event use:

    DoCmd.ApplyFilter , "Put your filter criteria here"

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 08-17-2008, 12:19 PM
  2. Replies: 2
    Last Post: 12-01-2006, 07:23 AM
  3. Replies: 0
    Last Post: 11-17-2006, 09:38 AM
  4. Automatic Syncronization
    By Katada in forum Programming
    Replies: 0
    Last Post: 04-25-2006, 03:36 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums