Create a command button that runs the Filter By form function

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Donna said:
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?
Click to expand...

DoCmd.RunCommand acCmdFilterByForm
 
Okay, I got that to work, but now how do I get it to execute the filter
without using the toolbar?
 
Donna said:
Okay, I got that to work, but now how do I get it to execute the filter
without using the toolbar?
Click to expand...

Ooh...don't think you can except to perhaps assign an AutoKeys macro to a
specific keyboard key.
 
Okay, I got that to work, but now how do I get it to execute the filter
without using the toolbar?
Click to expand...

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
 
Back
Top