How to clone a command button action

[ilikesta]

I want to clone an action button in an Access 97 form, but have it update multiple fields in related records. The current button only updates one field.

The code I am looking at and copying/pasting to my new button is:

    ' update the follow-up date in the remaining members of this debtor group
    Dim strSQL As String
    strSQL = "update DEBTORS set [UNTL] = '" & Me.UNTL & _
            "' where [DCODE] = '" & Me.DCODE & "';"
    DoCmd.SetWarnings False
    DoCmd.RunSQL strSQL

The UNTL field is updated in that action, but I want to update multiple fields, those being L4, PHONE, BLDG, STREET,CITY,ZIP,AREA

How do I update multiple fields by that command button action?

[nico5038]

Use an "expanded" SET command like:

UPDATE tblA SET A = 123, B = 456, C = "test"
WHERE A <> 234
 

Nic;o)

[ilikesta]

I finally found the proper syntax:

strSQL = "update DEBTORS set [UNTL] = '" & Me.UNTL & _
"', [AREA] = '" & Me.AREA & "' [L4] = '" & Me.L4 & "', [PHONE] = '" & Me.PHONE & "', [BLDG] = '" & Me.BLDG & "', [STREET] = '" & Me.STREET & "', [CITY] = '" & Me.CITY & "', [ZIP] = '" & Me.ZIP & "' WHERE [DCODE] = '" & Me.DCODE & "';"

Just some comma placement between the fields to be updated! I knew it was simple.

Again, this was Access 97

[nico5038]

When you know, it's always simple :-)

Well done, stringing this much as always a daunting task.

Success with your application !

Nic;o)