Filter by form and Apply Filter

  • Thread starter Thread starter JF Bouthillier
  • Start date Start date
J

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
 
Try:

* Filter-By-Form:

DoCmd.RunCommand acCmdFilterByForm

* Apply Filter

DoCmd.RunCommand acCmdApplyFilterSort
 
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.
 
When I click on the 'Filter-By-Form', the 'Apply Filter'
does not work. Any suggestions?

Thank you,
JF
 
JF Bouthillier said:
When I click on the 'Filter-By-Form', the 'Apply Filter'
does not work. Any suggestions?
Click to expand...

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.
 
Back
Top