Controlling multiple criteria filters

[ScubaBart]

Say I have a form that I opened with a certain filter (I tend to use the Where this = that format) and then I apply another filter to the content (usually in a continuous form).

I then want to remove the 2nd filter but not the first filter that was applied when the form opened.

I'm guessing I would have to explicitly reconfigure the 2nd filter to be all inclusive ? If I set the FilterOn property to false, it would remove all the filter criteria, even the conditions set when the form opened, right ?



Just trying to get a grasp on this before I dive in head first and start making adjustments.

[Welshgasman]

Setting FilterOn to False does just that. It doesn't affect the filter.
Try it and see.

[pbaldy]

In a brief test setting FilterOn to false removes the filter applied by opening the form with a wherecondition. I might pass the original filter in OpenArgs so you can go back to it as desired.

[Welshgasman]

In a brief test setting FilterOn to false removes the filter applied by opening the form with a wherecondition. I might pass the original filter in OpenArgs so you can go back to it as desired.

Wow, I never knew that.
My apologies @ScubBart. I have literally just set a filter off and then back on and left the filter alone.
However in my testing, after setting filteron to False, if I use Toggle Filter from the ribbon, the filter is set again.

So I tested this from the command window and I get the filter still set?

docmd.OpenForm "frmPressure",,,"pressureID <30"
forms!frmpressure.filteron = false
? forms!frmpressure.filter
pressureID <30

[CJ_London]

The where parameter of openform is badly named as it just applies a filter. It just prioritises those records to display before you can use the form - the rest of the table/query will continue to load in the background.

Five options:
1: include a criteria to the query before opening the form
2: use openargs to pass the criteria to the form and in the open event modify the recordsource to include the criteria
3: in the form load event , capture the filter and use that instead of “” when the filter is to be cleared (won’t work if using the form filter features)
4: similar to 1, use the equally poorly named filter parameter to specify a query where the criteria is specified
5: put your form as a subform and use the linkchild/master properties to set the initial filter

for very large datasets or complex queries I recommend using 1 or 2 for performance reasons and limit the amount of data brought through

[pbaldy]

Wow, I never knew that.
My apologies @ScubBart. I have literally just set a filter off and then back on and left the filter alone.
However in my testing, after setting filteron to False, if I use Toggle Filter from the ribbon, the filter is set again.

So I tested this from the command window and I get the filter still set?

docmd.OpenForm "frmPressure",,,"pressureID <30"
forms!frmpressure.filteron = false
? forms!frmpressure.filter
pressureID <30

Unless I misunderstood, the problem is that further filters get applied, so perhaps:

pressureID <30 AND Blah = 123

The problem is how to go back to

pressureID <30

Hence my suggestion of putting that in OpenArgs. That all said, I may have misunderstood and thus be all wet.