ADO Recordset problem

[cajsoft]

I assume that COMPUTE returns the results as a separate recordset. Have you tried NextRecordset?
Something like this:

Dim rst As Recordset
    Set rst = New Recordset
    rst.Open ("....")
    'do stuff, then get the next recordset
    Set rst = rst.NextRecordset

Thanks for replying,
however, I get the following error 'Operation is not allowed when the object is closed'

also I dont think I can change use the nextrecord set as I need records from both record sets in a while loop.

e.g.

set rs  =  oconn.execute(strSQL,blah,blah)
set rs2 = rs.nextrecordset

while not eof rs      ' Loop through data on both recordsets.

       rs.fields("Answer")
       rs2.fields(0)
loop