Updating a particular record in a table from a form

[Vasago]

Trying to update a record based on a unbound field on a form named punch id. I am getting a syntax error.

DoCmd.RunSQL "Update [Copy of Employee Work Statistics1] SET "[Trip Sign off] = '" & Me!Trip_S_off & "'"  WHERE [Punch ID] = forms![Royal Time Stamp]![Punch ID]"

[Seth Schrock]

Remove the double quote after the SET keyword.

[Vasago]

Thanks for your reply seth. I am still getting a syntax error

DoCmd.RunSQL "Update [Copy of Employee Work Statistics1] SET [Trip Sign off] = '" & Me!Trip_S_off & "'"  WHERE [Punch ID] = forms![Royal Time Stamp]![Punch ID]"

[Seth Schrock]

Is there a message and or number that goes with the error?

You also have an extra double quote right before the WHERE.

[Vasago]

Removing the extra quotes made it work perfect. Thank you for the help Seth