DAO recordset field reference syntax

[GraeagleBill]

Below is an attempt to move field contents from a single record within a DAO recordset. The MsgBox is simply confirming correct data content. The two assignment statements that follow the MsgBox confirm that the contents of field "Mov1" and "Mov1t" do in fact exist and can be assigned to corresponding unbound text boxes. However, when I attempt to loop through 16 sets of ordered-pairs I get the error the item not found in collection.



I'm concluding the expression rsReplicate!Field("Mov" & I) is syntactically incorrect? Yes?


The code:

 
    'Load up the unbound controls from the 16 Movements/Parts and their times
    
    MsgBox rsReplicate!Mov1 & " " & rsReplicate!Mov1t

    Me.tbMov1 = rsReplicate!Mov1
    Me.t1 = rsReplicate!Mov1t
    
    For I = 1 To 16
        Me("tbMov" & I) = rsReplicate!Field("Mov" & I)  <<<<<<<<<<<<<<<<< Field reference must be wrong????
        Me("t" & I) = rsReplicate!Field("Mov" & I & "t")
    Next I

The MsgBox display:


The error:

[CJ_London]

it is

rsReplicate.Fields("Mov" & I)

[GraeagleBill]

Lucky guess:

    'Load up the unbound controls from the 16 Movements/Parts and their times
        
    For I = 1 To 16
        Me("tbMov" & I) = rsReplicate.Fields("Mov" & I)
        Me("t" & I) = rsReplicate.Fields("Mov" & I & "t")
    Next I

[GraeagleBill]

Ha Ha Ha!! I just posted my "Lucky guess" and then saw your correction. I had "Splat" on the brain.
Bill