By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,652 Members | 1,448 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,652 IT Pros & Developers. It's quick & easy.

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

P: 5
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.
Aug 17 '07 #1
Share this Question
Share on Google+
3 Replies


ADezii
Expert 5K+
P: 8,607
[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
  1. 'Filter by Form
  2. DoCmd.RunCommand acCmdFilterByForm
Expand|Select|Wrap|Line Numbers
  1. 'Apply Filter
  2. DoCmd.RunCommand acCmdApplyFilterSort
Expand|Select|Wrap|Line Numbers
  1. 'Remove Filter
  2. DoCmd.RunCommand acCmdRemoveFilterSort
Aug 17 '07 #2

P: 5
You are a legend! Thanks for your help!
Aug 17 '07 #3

P: 5
Sorry for buggin, But how do i keep the "Apply Filter" Button Active while the Form is in Filter mode? Cheers
Aug 17 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.