I need to retrieve data from a recordset. The columns are numbered 45 to 85, and the rows from 1 to 55. To select the correct column I am using a variable and trying to use that to call the column.

Private c_x As Integer
c_x = x

c_CV = rsSample("c_x")

The c_x will not work. If I insert an integer such as 68 into it:

r_CV = rsSample("68")

It will. I need to use a variable. How can I do this?