Help with submitting unbound object values to table

[forbzinator]

Hi guys new member here! Looking for assistance.

I have a table called ActivationAttempt1 with the following fields: [WF Reference] (This is a lookup field which pulls the id from my main table), [Agent Name], [Date of call] etc etc

I also have a form with several corresponding fields for the end user to fill in. I have also included a text box which pulls through the relevant [WF Reference] that I want to update called [LinkID].

My issue arises when I try to update the unbound controls into the respective row in my table.

I have tried various things that I have found on the forum no avail. I believe I need to use a combination of:

[FONT=Times New Roman]UPDATE ActivationAttempt1[/FONT]
[FONT=Times New Roman]SET ActivationAttempt1.[Agent Name]=[Form_Agent Name], ActivationAttempt1.[Date of Call]=[Form_Date of call][/FONT]
[FONT=Times New Roman]WHERE ActivationAttempt1.[WF Reference]=[LinkID][/FONT]

I am trying to attach the above to an onclick event with a command button but get the following error: "The expression you entered contains invalid syntax. you may have entered an operand without an operator"

Please help I am pulling my hair out with this!:banghead: