Filter By Form blanks out buttons including ApplyFilterSort

[kattatonic1]

Using Access 2010. My users would love to use the Filter By Form feature. I am trying to set up simple buttons for this seemingly simple technique.

So I have a successful button that executes just this code:

DoCmd.RunCommand acCmdFilterByForm
DoCmd.RunCommand acCmdClearGrid

Hooray! That is, it takes them to the cleared form to allow them to type in &/or select criteria for their search. Now I need a button to allow them to execute the filter. Sounds simple!

I have created a button with just this code:

DoCmd.RunCommand acCmdApplyFilterSort

That button however gets greyed out every time the Filter By Form mode is activated. So we can't use the button exactly when we need it.

Any ideas?

Kay in Toronto

[ItsMe]

Filter by form is going to use Access' Wizard to get parameters from the user. The wizard will take over until after the user exits. One alternative is to....

Programmatically adjust the form's filtrer property.

Me.Filter = "Insert Where Criteria Here."
Me.FilterOn = True