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?
Re: recordcount on a table type recordset
Hi,
Use .movelast statement before record count.
Santulan
Santulan
Re: recordcount on a table type recordset
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