Could you otherwise include the condition in the query? If so, use such a
query upon which to open the recordset. Otherwise, I am not certain what you
mean... if you are reading the records one by one, and your test determines
the condition, just do nothing with the current record, and go on to the
next.
But, I'd guess there must be more to it than that. If so, please clarify.
Also, just an aside: if you will devote a minimum of time and effort to
learning how Access works with bound forms and work _with Access_ instead of
trying to defeat the way it works, it is almost never necessary to use
unbound forms in processing your data. And, once you get comfortable with
working "the Access way", it is significantly less effort, as well, because
you aren't re-implementing functionality that Access already provides as you
must with unbound forms.
Larry Linson
Microsoft Access MVP
