Re: Recordset.RecordCount is wrong ??



Nikos,

Thanks for the quick response.

I have done what you suggested and it does correct the value in the
recordcount, thank you.

Regards,

Steve Perrins



"Nikos Yannacopoulos" <nyannacoREMOVETHIS@xxxxxxxxx> wrote in message
news:%23AJFbi7rGHA.4004@xxxxxxxxxxxxxxxxxxxxxxx
Steve,

This is a VBA / DAO bug, I believe... to get the correct recordcount, you
need to force a move away from the first record first. Try:

rs.MoveLast
rs.MoveFirst
MyVal = rs.RecordCount

to get the correct number.

HTH,
Nikos


.