[RESOLVED] rewriting recordset name field

[jlbantang]

having these fields

print rs!address1
print rs!address2
print rs!address3

i want to loop through to the NAME FIELD (not FIELD INDEX)

for i=1 to 3
print rs!address & i
next

but the compiler returns that rs!address & i is no where to found in the recordset collection.

[jlbantang]

opps i figure it out:

for i=1 to 3
print rs("address" & i)
next