I use the tipical

While Not RS.EOF

rs(0)
rs(1)
move.next

....
wend

and have an acces table with field name CODE1, CODE2, CODE7, CODE9....

During the while not loop the value in rs(0) can assume CODE1, OR CODE2 ....
and rs(1) can assume value 1 or 14

How to insert the related avlue of rs(1) into the table where the filed name is the value of rs(0)...

in thi case the final table is:
CODE1 CODE2
1 14