Hi!

As far as I know, RecordCount do not always return the proper value. It is always proper only for client-side recordsets. Try to open record sets other way by using the direct creating of the recordset object and using its Open method with specifying of the exact recordset type.

>Hi all, can anyone tell me why I am getting 5 results back from my rsDiv query and only one result back from my rsProdLine query? Has anyone encountered this type of behaviour before? Am I using the wrong syntax? I'm pretty new to ADO soo..... btw - it is an access db not a foxpro db...
>
>
>Dim db As Database
>Dim rsDiv As Recordset
>Dim rsProdLine As Recordset
>
>Set db = CurrentDb
>Set rsDiv = db.OpenRecordset("select distinct division as div " + _
> "from productline]")
>Set rsProdLine = db.OpenRecordset("select productline " + _
> "from productline")
>
>MsgBox rsDiv.RecordCount
>MsgBox rsProdLine.RecordCount