Simon,
Requery does not work for changed filters, the docs are wrong, it only work for
parametrised recordsets.
You should look at the knowledgebase (GO MSKB) for a list of articles about the
problems with requery. Try searching for "MFC" and "requery".
-Ronald-