When open the report the filter is off

  • Thread starter Thread starter Frank Situmorang
  • Start date Start date
F

Frank Situmorang

Hello,

Waht is the VBA or How can we say on the open event of the report, when we
open it, the filter will automaticall off.

Thanks very much
 
In Access 2007, forms and reports have a FilterOnLoad property. Set this
property to No.

In earlier versions, anything in the filter property is not applied by
default. You had to set the FilterOn property to True before it was applied.
You could set FilterOn to False in Report_Open if you want A2007 to behave
the same as earlier versions.

Note that a filter is not applied if the report is already open.
 
Allen,

Thanks very much Allen, I just change the propery Filter on to false at the
start up.
 
Back
Top