Open Filterdialog with VBA

[Gijs]

Hi Guys,

Does anybody know how to open the regular filterdialog (with the checkboxen for the different values) in a report with VBA. With the regular filterdialog I mean the one you get when you select a column and then push the filterbutton.


Thanx in advance!

 

[vbaInet]

Not sure why you need it but here:

DoCmd.RunCommand acCmdFilterMenu

 

[Gijs]

Thanx a lot!

I need it because i don't want the accessribbon in my application.

 

[vbaInet]

Makes sense!