Syntax error in UPDATE query

[GraeagleBill]

Can't seem to find syntax problem with the statement below. (intPCID is dim'd integer. PCNotes and PCID are fields in table tblPerCaps. tbNotes is a text box.)

CurrentDb.Execute "UPDATE tblPerCaps SET PCNotes = " & Me.tbNotes & " WHERE PCID = " & intPCID & ";", dbFailOnError

[isladogs]

Assuming it's a text field, use text delimiters - shown in RED

CurrentDb.Execute "UPDATE tblPerCaps SET PCNotes = '" & Me.tbNotes & "' WHERE PCID = " & intPCID & ";", dbFailOnError

[ranman256]

if you use a query instead of sql, it will show you the errors.

[GraeagleBill]

At 2AM I completely forgot I was dealing with SQL syntax. So yes, character strings always require proper delineation in SQL syntax.

Thanks for the wake-up,
Bill

[GraeagleBill]

Good point, I'll remember that for future reference.