Filter By From, Apply Filter, Remove Filter Buttons in a Form.

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.

ADezii

[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:

Expand|Select|Wrap|Line Numbers

 'Filter by Form

DoCmd.RunCommand acCmdFilterByForm

Expand|Select|Wrap|Line Numbers

 'Apply Filter

DoCmd.RunCommand acCmdApplyFilterSort

Expand|Select|Wrap|Line Numbers

 'Remove Filter

DoCmd.RunCommand acCmdRemoveFilterSort

mattscho

You are a legend! Thanks for your help!

mattscho

Sorry for buggin, But how do i keep the "Apply Filter" Button Active while the Form is in Filter mode? Cheers

Filter By From, Apply Filter, Remove Filter Buttons in a Form.

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

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

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

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about