Why does Recordset only return one record?

Question

I am trying to open a recordset in Access, based upon a pre-defined query but it is only ever finding one record. (Once I can get more than one record then I will develop the code!). I have tried substituting the query with a table, but the result is the same.

I am sure that this is something simple and obvious......but it is eluding me!

The code is :-

    Dim dbs As Database

    Dim rst As DAO.Recordset

    Set dbs = CurrentDb()

    Set rst = dbs.OpenRecordset("qry5050Entries")

    MsgBox rst.RecordCount

    rst.Close

    dbs.Close

Answer 1

You need to move to the last record before the record count reflects the correct value.

http://msdn.microsoft.com/en-us/library/office/bb243791(v=office.12).aspx