The recordset objet exposes one record at a time. If you want to deal with the values in another record, you must first move to it. You cannot work with the values of two or more records at once unless you have two recordsets open.
You CAN capture field values for one or more records at once into an array variable using the getrows or getstring methods. These methods put all the field values into an array that you can then use in your code however you want. If this is what your after I would suggest you read up on the getrows method.
where rows=number of rows to return, start=the record to start at (0=current, 1=first, 2=last) and fields= a single field name or an array of field names or an array of ordinal positions of the fields.The order in which the field names are listed dictates the order in which they are returned.
So in your case, if you want to use rows 1, 4 and 10, you would do:
Using this method as shown in the above command line, the array arrDBvalues is then automatically populated with the values of all the fields of all the records from the starting record to the 10th record.
You could then manipulate the values of the records from the contents of the arrDBvalues array.
Note that this allows you to open the recordset, do the getrows command to capture ALL the data values at once, and then close the recordset immediately. (Very efficient and very good programming practice). Then, the values are stored in the 2 dimensional array arrDBvalues for you to use however you wish.
Hope this helps.
Type Getrows into your favorite search engine, and you'll get a lot of websites with good examples of how to use it.