Create a command button that runs the Filter By form function

[Guest]

I have a form that tracks all phone calls received - it has about 15
different fields on it that pertain to each call (who took the call, caller
name, what they wanted, etc.

Since the dept. will get 2000 calls a month, I need a way for them to search
easily and using any and all fields to perform the search. I know how to do
that using the Filter by Form function, however, they won't have that toolbar
available to them so how can I create a command button that will activate the
filter by form function instead?

 

[Rick Brandt]

I have a form that tracks all phone calls received - it has about 15
different fields on it that pertain to each call (who took the call, caller
name, what they wanted, etc.

Since the dept. will get 2000 calls a month, I need a way for them to search
easily and using any and all fields to perform the search. I know how to do
that using the Filter by Form function, however, they won't have that toolbar
available to them so how can I create a command button that will activate the
filter by form function instead?

DoCmd.RunCommand acCmdFilterByForm

 

[Guest]

Okay, I got that to work, but now how do I get it to execute the filter
without using the toolbar?

 

[Rick Brandt]

Okay, I got that to work, but now how do I get it to execute the filter
without using the toolbar?

Ooh...don't think you can except to perhaps assign an AutoKeys macro to a
specific keyboard key.

 

[fredg]

Okay, I got that to work, but now how do I get it to execute the filter
without using the toolbar?

You could create your own custom toolbar, with just the Toggle Filter
tool button.

In the Form Open event:

DoCmd.RunCommand acCmdFilterByForm
DoCmd.ShowToolbar "CustomToolbarName", acToolbarYes

In the form close event:

DoCmd.ShowToolbar "CustomToolbarName", acToolbarNo