Run-time error '3075':
Extra ) in query expression
Dat is a String
Serial is a String
AComment is Long Text in the table
Prefix is Short text
What am I doing wrong ?
Extra ) in query expression
Code:
DoCmd.RunSQL ("UPDATE tblmain4 SET [AComment] = " & Dat & " WHERE [Prefix] = '" & Serial & "'")
Serial is a String
AComment is Long Text in the table
Prefix is Short text
What am I doing wrong ?