I am trying to get a correct recordcount from a recordset that
references a linked table as the source.
Here is the code:
Dim db1 As DAO.Database
Dim rs1 As DAO. Recordset
Set db1 = CurrentDB()
Set rs1 = db1.OpenRecordSet("tbl_CID", dbReadOnly)
Debug.print rs1.RecordCount
When this code is executed, the Immediate window shows the printed
value to be 1, where there is actually 136 records in the table.
Any ideas what might be the cause of this?
Regards,
Charles