Handling Two Recordsets from a Stored Proc

[joebickley]

Hi I have a stored proc that returns two recordsets. Is it possible to use both of them in VBA as i can only seem to pick up the 1st one that is returned.

Thanks

Joe

 

[cmmrfrds]

Use the NextRecordSet Method of the ADO recordset.

Example.
Dim rs1 as New ADODB.Recordset, rs2 as New ADODB.Recordsete

rs1.Open yoursp, yourconn

if not rs1.eof then
do something
end if

Set rs2 = rs1.NextRecordset

 

[joebickley]

Perfect, thanks muchly