Within VBA behind a form, I have the following statements:
strinsert = "INSERT INTO [tblExportMSR] ( [Title], [ISBN 13], [Series #], [Quantity]) values (" & "'" & strbName & "'" & "," & "'" & strbISBN13 & "'" & "," & "'" & strbSeries & "'" & "," & "'" & strbOrderQty & "'" & ")"
DoCmd.RunSQL strinsert
This works perfectly until one of the values within one of the variables contains a '. An Example is:
strbname = NH Trees & W'flowers
I can't figure out what the syntax should be. Thanks for your assistance!!