Updating a record

[Junkie88]

I am trying to save the value of a text field on the access form into a table using Update statement.

CurrentDb.Execute "UPDATE PATIENT SET DROPOUT_REASON = '"&
txtReasonDO.Value & "' WHERE PATIENT_ID = "& 1 & ";"

I get errors when I have commas or quotation marks in the text fields, but when I remove all the punctuation then it is working fine. Anyone knows how I can save the text fields, so it also allows me to store commas and quotations.

 

[PHV]

CurrentDb.Execute "UPDATE PATIENT SET DROPOUT_REASON='" & Replace(Me!txtReasonDO, "'", "''") & "' WHERE PATIENT_ID=1;"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886