Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    how to bypass or avoid a filter (97)

    my data entry form uses vba code to filter based on the operator. I however would like to enter the form and view all records with no filter required, is this possible? I wanted to do this via a macro. It might be a bit of a mess seeing as how I

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: how to bypass or avoid a filter (97)

    Are you talking about an Access macro or a Sub? Why would you want to use a macro when they lack the flexibility and control of VBA code and when good macros are as hard to write as code?

    Try explaining more about how you normally open the form (i.e. when a user opens the form) and how the filter is applied. Otherwise, we're just guessing at how to answer you.
    Charlotte

Posting Permissions

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