Output to SNP

  • Thread starter Thread starter Newbie
  • Start date Start date
N

Newbie

Using a runtime version of Access -
can I set the filter properties of the report at runtime?


eg: Reports!Sales12mthRolling.Filter = strFilter
Reports!Sales12mthRolling.FilterOn = strFilterOn

strFilter is a string
strFilterOn is yes/no

I usually do this in design mode

If not how can I achieve the samething?
 
FilterOn is a boolean property: you should be passing it True (-1) or False
(0), not a string.
 
Back
Top