cycling through a recordset, storing info to a 2-dimensional array

can someone let me know how to cycle through every record in a recordset, when i try it it gets to the end of the database, and gives an end of file error.

i have tried looping until data1.recordset.eof, but it still give the error. how do i avoid the error?

------------------

Wossname,
Email me: [email protected]