Need Filter By Form Help

[Ryan C.]

I have created a form that opens in "Filter By Form" mode, but I when I
create a Command Button to "Apply Filter" the button is greyed out. The
"Apply Filter" is essentially the same as the Funel icon in the menu bar.
Does anyone know how to enable the "Apply Filter" command button when in the
"Filter By Form" mode?

Thanks.

 

[Van T. Dinh]

I don't usually do this but my guess is that you have placed the
CommandButton in the Detail section of the Form and any Controls without
values in the Detail section will be greyed out on "Filter-By-Form" mode.

(Guessing only) Try placing the CommandButton in the Form_Header section.