getrows problem with a dao recordset

[Guest]

sometimes when I call getrows from a dao recordset, I get only one row of
data, instead of all rows. This happens even though I haven't called
movefirst or movelast. how do I prevent this from happening and ensure I
get all records?

I'm using Access 2000.

 

[Allen Browne]

The RecordCount refers to the number of records retrieved so far. MoveLast
if you want the accurate count.