I'm having an issues when I try to add a string of characters that includes an apostrophe. Here is the string...
SAM's (Somewhere, IL 61108 - UPS Ground)
It works fine without the apostrophe.
and here is the not in list code:
strSQL = "INSERT INTO tbSamplesTypesLU ([Description],[CustomerID]) VALUES ('" & NewData & "'," & Me.Parent.cboCustomerID & ");"
Can someone spot my problem?