Make "Apply Filter" button in a form stay active when in filter mode

[mattscho]

Re: Filter By From, Apply Filter, Remove Filter Buttons in a Form.
--------------------------------------------------------------------------------

[quote=mattscho]Hi All, Trying to create a set of 3 buttons in a form that have the same effect as the "Filter by Form", "Apply Filter" and "Remove Filter" Buttons on the access toolbar. Help would be muchly appreciated. Cheers.[quote]

In the Click() Event of 3 Command Buttons, place the following code:
Code: ( vb )
'Filter by Form
DoCmd.RunCommand acCmdFilterByForm



Code: ( vb )
'Apply Filter
DoCmd.RunCommand acCmdApplyFilterSort



Code: ( vb )
'Remove Filter
DoCmd.RunCommand acCmdRemoveFilterSort


Hi, Does anyone know how to make the "Apply Filter" button stay active while in filter mode in a form. Cheers

[puppydogbuddy]

[quote=mattscho]Re: Filter By From, Apply Filter, Remove Filter Buttons in a Form.
--------------------------------------------------------------------------------

[quote=mattscho]Hi All, Trying to create a set of 3 buttons in a form that have the same effect as the "Filter by Form", "Apply Filter" and "Remove Filter" Buttons on the access toolbar. Help would be muchly appreciated. Cheers.

In the Click() Event of 3 Command Buttons, place the following code:
Code: ( vb )
'Filter by Form
DoCmd.RunCommand acCmdFilterByForm



Code: ( vb )
'Apply Filter
DoCmd.RunCommand acCmdApplyFilterSort



Code: ( vb )
'Remove Filter
DoCmd.RunCommand acCmdRemoveFilterSort


Hi, Does anyone know how to make the "Apply Filter" button stay active while in filter mode in a form. Cheers

See this link for code samples of functions built around these commands. Click the applicable hyperlink on the link below to go to the actual code. It takes more then one line of code to make each function emulate the functionality available from the toolbar.

http://home.clara.net/tkwickenden/code/codingf.htm