Form Filters

[dadrew]

I want to place a button on a form to create a form filter. When I place a command button I can get from the wizard an 'Edit Form Filter' command or a 'Apply Form Filter' Command. Is there a way that I can make a button to 'Create a Form Filter' and to 'Clear a Form Filter'. I'm aware that I can create the filters from the tool bar, but I wasnt the buttons on the form. Cheers!

 

[a.sinatra]

DoCmd.RunCommand acCmdToggleFilter

You can try that, it turns the filter on and off.
________
Mercedes-Benz 240D Specifications

 

[dadrew]

Form Filter Buttons

OK ive done as you suggested. The problem now is that when I click my new button 'Filter by Form' It disables all other buttons on the form. Is there a way that I can make some of them i.e. 'Apply Filter' continuousley active, Cheers

 

[dadrew]

Re Filter Buttons

Can anybody help with this?

 

[ddrew]

Evidentaly Not!

 

[andy_dyer]

This isn't great, but after getting no response either I worked this out!!

http://www.access-programmers.co.uk/forums/showthread.php?t=62303

Hope this helps!