oops, my bad. i should have said FindFirst. thanks for the catch, David.
tina


"David W. Fenton" wrote in message
36.91...
"tina" wrote in
:

suggest you use the Find method instead. or, base the recordset on
a SQL statement that includes criteria to return the desired
records only, instead of basing the recordset directly on a table.

and btw, suggest you declare the recordset type as DAO.Recordset,
rather than simply Recordset.

Your advice is contradictory. Suggesting using Find indicates an ADO
recordset, but then you suggest using a DAO recordset, which uses
FindFirst.

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