Filter by form and Apply Filter

[JF Bouthillier]

Hi all,

I would like to have command buttons to 'Filter By Form'
and 'Apply Filter' in my form (not toolbar). What are
the two VBA lines that would allow me to do that?

Thank you,
JF

 

[Van T. Dinh]

Try:

* Filter-By-Form:

DoCmd.RunCommand acCmdFilterByForm

* Apply Filter

DoCmd.RunCommand acCmdApplyFilterSort

 

[Rick Brandt]

However; the second command below cannot be run from a button on the form as
Filter-By-Form will disable all buttons on the form.

 

[JF Bouthillier]

When I click on the 'Filter-By-Form', the 'Apply Filter'
does not work. Any suggestions?

Thank you,
JF

 

[Rick Brandt]

When I click on the 'Filter-By-Form', the 'Apply Filter'
does not work. Any suggestions?

See my previous post in this thread. The apply filter button cannot be on the same
form. You will have to put it in a toolbar.