You used the same connection, but are the settings for the recordsets themselves different? Specifically, is the second recordset a SERVER-side, while the first one is CLIENT-side? I believe that would cause the problem you are seeing.

Vin


>hi everybody,
>
>i open a recordset it works fine when i checked recordset.reocrdcount it returns number of records.
>
>when i open 2nd recordset useing same connection it works fine but cannot return number of records useing recordset.recordcount, it returns -1. whereas it has records reteriving by database.
>
>for first recordset i use this code
>
>allRec = recordset1.recordcount
>it works fine
>
>for 2nd reocrdset
>allRecProduct = recordSet2.recordcount
>it returns -1.
>
>when i populate a combo by 2nd recordset it works successfully. the code is
>
>do while not recordset2.eof
> combo1.additem recordset2.fields("Name").value
> recordset.movenext
>loop