Form Recordsets, Requery and FilterOn=False

[David W. Fenton]

I was just working on an A97 app in which has lots of filtering and
dynamic changing of the recordsets, but also uses bookmark
navigation of subsets of records. I was trying to implement some
fixes for some very rare conditions where the FIND dropdown doesn't
list the same dataset as the form.

I always code bookmark navigation with a With Me.RecordsetClone, and
not thinking too carefully, I added a requery after the first
NoMatch and then another try at the .FindFirst. This worked! Then,
since filters could be in place that are not reflected in the find
dropdown, I removed the filter and repeated the .FindFirst if there
was a .NoMatch after the requery. This one told me that the With
object had been invalidated.

What this tells me is that in A97:

1. a requery within a With Me.RecordsetClone block does *not*
invalidate the RecordsetClone.

2. a Me.FilterOn = False *does* invalidate the RecordsetClone.

This rather surprises me. I'd have expected *both* to invalidate it.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/