Filter property

  • Thread starter Thread starter david epsom dot com dot au
  • Start date Start date
D

david epsom dot com dot au

The A2K and A97 help files say that:
'The filter and WHERE condition you apply become the setting of the report's
Filter property.'

Is this true? I've tried
msgbox me.filter
and it is coming out blank???

(david)
 
Hi David.

This work correctly for forms, but Access does not maintain the FilterOn
property for reports so it would not surprise me if the Filter is not
handled correctly either.

Additionally, if you have multiple instances of a report open, and try to
apply a filter, Access is likely to apply it to the wrong instance, even if
you have clearly specified the instance such as Me.Filter = ...

Other bugs with filters:
http://members.iinet.net.au/~allenbrowne/bug-02.html
 
Back
Top