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.)
Code:CurrentDb.Execute "UPDATE tblPerCaps SET PCNotes = " & Me.tbNotes & " WHERE PCID = " & intPCID & ";", dbFailOnError