>How can I test if a recordset contains 0 records so I can skip calling the Move() mehods so that I can avoid the "No current record" error message generated by VB 5.0?
The RecordCount property is not always good (it can sometimes returns -1 even if you have data in the recordset!). It is better to check this way:
If rst.bof and rst.eof then
'The recordset is really empty.
end if
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com