>is rs.RecordCount as totaly worthless as I think it is or am I just too tired to see straight?
>
>I really would prefer NOT to loop through to get a Record Count ...
>
>Please forgive any spelling or gramatical errors, its been a very long week. :(

Certain types of ADO cursors do not support the RecordCount property. For example, the default (client side) forward and read only cursor always returns -1 or some other negative number.

Are you using server or client side cursor? I believe static type cursors do return the correct record count.