save filter in form

  • Thread starter make a VBA to export pivot chart to word
  • Start date
M

make a VBA to export pivot chart to word

how do i ensure that the filter i used in a subform remains the same when
next i open the subform without having to reapply the filter
 
J

John Vinson

how do i ensure that the filter i used in a subform remains the same when
next i open the subform without having to reapply the filter
Click to expand...

Simplest is not to use a filter at all; instead, base the subform on a
Query which returns the appropriate records.

John W. Vinson[MVP]
 
M

make a VBA to export pivot chart to word

well i would want to change the filters often and would not want to have to
go to the query everytime
 
J

John Vinson

well i would want to change the filters often and would not want to have to
go to the query everytime
Click to expand...

So? Is it any harder to change the parameter in a Parameter query than
it is to change a filter?

I'd use a criterion like

=[Forms]![frmCrit]![txtCriterion]

referencing an unbound textbox on an unbound form; that way you can
change the criterion whenever you like.

John W. Vinson[MVP]
 
Top