"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/