Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    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
    Sacramento, California, USA
    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.

Posting Permissions

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