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