How do I create a menu button for 'filter by form'

T

tezza

Hi (again),
I'd like to create a custom menu button for Filter by Form
Can someone tell me, in detail, exactly how I do this please or point me at
a good example?
Thanks
 
A

Allen Browne

If by "menu button", you are talking about a custom toolbar, you can just
Ctrl+Drag the Filter By Form button from the built-in toolbar onto your
custom one.

If you mean a command button, in its Click event you would call a macro that
uses the RunCommand action, and in the lower pane of macro design, choose
FilterByForm
 
6

'69 Camaro

Right-click on the menu bar and select Customize... on the pop-up menu to
open the Customize dialog window. Select the "Commands" tab and then select
the "Records" item in the left pane. Select the "Filter By Form" icon in the
right pane and drag it with your mouse to your custom menu bar or the
built-in menu bar. (Caution: any changes you make to the built-in menu bar
applies to all Access databases on your computer.) Select the "Toggle
Filter" icon in the right pane and drag it with your mouse to your custom
menu bar or the built-in menu bar. Close the Customize dialog window to save
your changes.

Open a bound form and these buttons on your menu bar will become enabled.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
 
Top