Setting Recordset values to a variable

Hello sir,
I am havign recordset created in MS-Access having "no1" field with different datas.

I want all that values to set to a only one variable

Pls do help me in this coding

Declare an array, connect to the database and populate recordset, loop through recordset and populate array from recordset.
Sample code can be found in VB FAQ forum.