By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,838 Members | 2,222 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,838 IT Pros & Developers. It's quick & easy.

Form Recordsets, Requery and FilterOn=False

P: n/a
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
usenet at dfenton dot com
Jul 21 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.