Set mRS = mCN.Execute("UPDATE Dies SET Die_Notes = '" & Note & "'" Where Tool_No = " & DieSelected)

Note is a string variable already declared and holds a note from an inputbox.

Dies is a table in Access 97
Die_Notes, Tool_No are fields in Access
DieSelected is the position in the datagrid


The problem is I get an Object missing error because I am not assigning the string variable Note properly. How do I add in Die_Notes = Note in to the select statement properly?