Access2000 Macro ApplyFilter

[Guest]

Please, Macro in Access97 runs ApplyFilter to a saved Filter offering an
input to search and select. Press button again it runs again.
Access2000 the same type of Macro runs ApplyFilter offering input once and
then re-applies filter using same input.

 

[Guest]

I just stumbled across your post - and although this is a few months later,
thought I might respond in case you still haven't solved your problem. This
problem is a bug in A2000. It can be solved in the macro by issuing two
(yes, two - one doesn't seem to work) ShowAllRecords commands before the
ApplyFilter. This seems to clear the buffer and cause the ApplyFilter to
work correctly. Microsoft used to say in their kb article that it can not be
fixed in an A2000 macro (I haven't looked lately, but they ignored my notices
to them and kept saying it can't be done with a macro) - but it can be done
and I have used it extensively for my clients who converted (against my
advice) to A2000.