Hi there,
I have a table which has 4 records. I use the followings to count the records:
Dim rst As Recordset
Set rst = CurrentDb.OpenRecordset("tbl_calc")
rst.MoveLast
aaa = rst.RecordCount
rst.MoveFirst
this returns 44 instead of 4 !!!!!
Any ideas?
Thanks
I have a table which has 4 records. I use the followings to count the records:
Dim rst As Recordset
Set rst = CurrentDb.OpenRecordset("tbl_calc")
rst.MoveLast
aaa = rst.RecordCount
rst.MoveFirst
this returns 44 instead of 4 !!!!!
Any ideas?
Thanks