recordcount on a table type recordset

Has anyone experienced the phenomenon of a table type recordset reporting an incorrect record count? I have 376 records in a table. When a dynaset type recordset object is used the correct # of 376 records is reported for its "recordcount" value. Although when I use the table type recordset the amount of 302 is reported for its "recordset" value. Can anyone help solve this mystery?

Hi,

Use .movelast statement before record count.

Santulan

Santulan

Sorry man you really didn't read my question did you? : )

I have refreshed the db by the .movelast .movefirst the problem that the tye dynaset reports the correct # of records while the type table does not. I am perplexed as to why this is happening