Output to SNP

[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?

 

[Douglas J. Steele]

FilterOn is a boolean property: you should be passing it True (-1) or False
(0), not a string.

 

[Newbie]

Yes I do pass it true/false but will this still work with a runtime version
of Access?

 

[Douglas J. Steele]

I believe it should (but I'm afraid I have no way to test)

 

[Newbie]

Thanks

I believe it should (but I'm afraid I have no way to test)