(NEWBIE) Double filter in a button

[Tiago Fernandes]

Like u can see on photos i'm trying to make a filter about the 2 boxes, but with the code that i use in others filters i can't built this new button that use 2 filters in same time can someone help with this.


Sorry if im not the best explaining problems.

Thank for all the support that u can give.

[Welshgasman]

Use strFiltro = strfiltro1 & " and " & strfiltro2

[ssanfu]

You might investigate this Search Form article by Allen Browne about filtering. The actual VBA code is here.

[Tiago Fernandes]

Thanks a lot for help.