Fill out a field list with a for ... next loop

[4vTurbo]

In a vb module I want to fill out the fields with a for ... next loop => see version2. But there is a problem. Can somebody knows the solution

Regards
Rolf


'====== Version1 ====

rs.Edit
    rs![feld1] = "User1"
    rs![feld2] = "User2"
    rs![feld3] = "User3"
rs.Update

'==== Version2 (with for .. next) don't work =====

rs.Edit
    For i = 1 To 3
        rs![feld & i] = "User" & i
    Next
rs.Update

[TheSmileyCoder]

You can reference fields by name like so:

rs.Edit
    For i = 1 To 3
        rs("feld" & i) = "User" & i
    Next
rs.Update