[RESOLVED] Update single row

[aikidokid]

I am trying to update a single row in an Access DB, with values from an array of 19 text boxes.

Table name is tbl_Membership
MembID is the row to be updated

Is this Update statement along the right lines?

Set cn = New ADODB.Connection
cn.ConnectionString = strConnection & App.Path & "\Membership.mdb"
cn.Open
    
strSQL = "UPDATE tblMembership Where MembID = " & lngSelection & _
            "Set Firstname = " & txtMembership(0).Text 
            "Set Middle_Name = " & txtMembership(1).Text
            'next 17 values inserted here
 
cn.Execute strSQL