rs.recordcount (inaccurate) 3

[philcon]

Hi there,

I know this is going to be a no-brainer, but could anyone tell me why the following code produces a record count of 1 rather than 4 (the number or records in the table)

Many thks in advance


Phil.

Private Sub Command141_Click()
Dim db As DAO.Database
Dim rs As DAO.Recordset

Set db = CurrentDb
Set rs = db.OpenRecordset("tbl_MailpackConsolidate", dbOpenDynaset)
Debug.Print rs.RecordCount

End Sub

 

[philcon]

Did I start all this ?

Sseriously though as someone who is trying to learn "good" vba coding, I have appreciated all posts so thanks all

Philcon