Filter function.....

[bmwccn]

I`ve got a form where I`m going to use filters. There is a choice called "filter by form" in the menues. Can a button on the form execute this action? The only thing I can find a button for is "Use filter" and "Modify filter"....
The "filter by form" action gives pulldown menues from all the parameters on the form, and thats why I wanna use it........

 

[adam_fleck]

Filter by form

Here you go:

DoCmd.RunCommand acCmdFilterByForm

If you paste this code into the click event for your button, that should do it.

 

[freddienet]

filter by form

Here you go:

DoCmd.RunCommand acCmdFilterByForm

If you paste this code into the click event for your button, that should do it.

I pasted the command into the clip event and when I clicked on the command button in the form I got a Macro error. Tips on a macro would be appreaciated.

Freddie