>I have a recordset that has a variable number or integers that I would like to add to an array. I then want to loop through this array during other subs and functions. Does anyone have some advice to get started?

Both DAO and ADO recordsets have a function called GetRows() that returns your data in a multidimensional array. You might need to do some transposing because the result gives you columns and rows that are the opposite of a recordset. HTH