[AccessD] recordset count = -1?

Are you sure it's a DAO recordset, Arthur?  ADO recordsets commonly
return 0 or -1.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Monday, November 12, 2007 11:47 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] recordset count = -1?

I've got a DAO recordset and codes that does rs.moveFirst and
rs.MoveLastand debug.print rs.RecordCount, but it consistently returns
-1, when I know there are records in the set. What am I doing wrong?

TIA,
Arthur
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com