how to bypass or avoid a filter (97)

[arage]

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

[charlotte]

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.