asked on

Cannot enable Apply Filter / Sort button

My form has no toolbar visible (by design)
I have a Command Button that activates Filter By Form (works fine)
My Apply Filter / Sort Command Button is greyed out and I cannot enable it.

Any ideas ?

ASKER CERTIFIED SOLUTION

Gustav Brock

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

mbizup

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Eirman

ASKER

so you cant even use the click event of a textbox disguised as a command button

I had already tried that!

Would a temporary Pop-Up form with three buttons work?

FILTER BY FORM

APPLY FILTER

CLEAR ALL FILTERS

SOLUTION

Dale Fye

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

mbizup

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Eirman

ASKER

Many Thanks

I'll probably use a custom toolbar in the short term and develop a separate search form

Eirman

ASKER

Toolbars & QAT are still hidden. I settled for this ...

FILTER BY FORM ............... Command Button > DoCmd.RunCommand acCmdFilterByForm
APPLY FILTER .................... Right Click on Form > Apply Filter/Sort
CLEAR ALL FILTERS ........... Command Button > DoCmd.RunCommand acCmdRemoveAllFilters

EDIT: This is better than acCmdRemoveAllFilters as it produces no errors if there is no filter in place.

Me.FilterOn = False
Me.Refresh

Open in new window