MSRDC

I am using a MSRDC data control to connect to an INFORMIX database. I have been using the following code successfully so far:

Dim my_sql as String
Dim x as Long

my_sql = "Select whatever From whatever ...."
MSRDC_name.SQL = my_sql
MSRDC.Refresh
x = MSRDC_name.resultset(0)

The ".resultset(0)" references the first value returned by the query and that value is successfully assigned to "x". I get an error when trying to reference subsequent returns as in ".resultset(1)" for the second value returned. The query definitely returning multiple values, so it is not a matter of the second value not existing.

Thanks.