Advanced filter mode

[misop]

Hello,

I have form with toggle buttons. On every button is a code to filter data. I want to have there code to enable or disable that filter (not all filters). I want that because users can press one or more buttons to filter data, and when they press again any button it clear every filter in range. I want to clear only that filter on button, which they pressed. Now I use this code:

Please Login or Register  to view this content.

Problem is in this part:

Please Login or Register  to view this content.

there is .ShowAllData, but I dont know the code which can replace that.

Can someone help me?

[HSV]

Will this help you.

Please Login or Register  to view this content.

[misop]

Thanks Harry,

I think it help me, but one more thing... if I press two buttons, It do not filter correctly:

Please Login or Register  to view this content.

In the second filter is entry, which do not respond to Criteria1 and there isnt entry from rd 3, which respond to Criteria1 of second button

The second button begin filtering on row 7... I dont know why

[HSV]

Maybe you can upload your file.

[misop]

here is... on the first row you find button Filter... under this is form with filter buttons

[HSV]

Remove the filters in row 2.
Add new filters.

Please Login or Register  to view this content.

[misop]

Thank you,

I think it isnt still working. First button "Budovy" is working well, but when you press second button "Inzinierske_stavby" there are records which doesnt met criteria and third button "Rezidencne_objekty" too, there is still record which doesnt met criteria.

EDIT: it filter only first 9 rows, 10 row is unfiltered with every button. I want to filter whole number of rows (there is no exact number.. rows are increasing every week)

Here is code for three buttons:

Please Login or Register  to view this content.

[HSV]

It works fine to me.

"Budovy" and "Inzinierske_stavby" has the same sortfield.
There are records "Budovy" and "Inzinierske_stavby" as well.
So if you filter "Budovy" its shows 4 items.
Filter then "Inzinierske_stavby", it will show 2 items.
The third button doesn't have criteria.

[HSV]

If you want all the three items.
Put in in a array.

Please Login or Register  to view this content.

[misop]

I addded into H10 entry Inžinierske stavby... when I press button Budovy this row shouldnt be in filter but he is... The third button has criteria "Rezidenčné", but when I press this button, there are entries which doesnt meet this criteria (Priemyselné objekty a sklady,...)

[misop]

This code helped me:

Please Login or Register  to view this content.

one more question: is there possibility to include other filters into pressed buttons? (when I press Inzinierske_stavby and Rezidencne_objekty there should be no entries). Now when I press 1st Inzinierske_stavby and 2nd Rezidencne_objekty, it filter me only Rezidenčné objekty