On my form I have a combo box with an On Not In List Event. To insert the new data in to the appropriate table I build up a SQL string as follows:

'Build up the SQL string to add new data.
strSQL = "INSERT INTO [tblMy Table Name]([fldItemName]) " & _
"VALUES ('" & NewData & "');"

I then perform the action

DoCmd.RunSQL strSQL

This works OK until the new data contains and apostrophe eg "Fred's CD". The error message 3075 - Syntax error, missing operator is displayed.

How can I resolve this problem?

Thanking you in advance.
pH

Try changing you SQL to:

RDH

Dear Ricky

Thanks for your suggestion.

It resulted in another VBA error - but it pointed me in the right direction. The solution that worked is

'Build up the SQL string to add new data.
strSQL = "INSERT INTO [tblMy Table Name]([fldItemType]) " & _
"VALUES (" & Chr(34) & NewData & Chr(34) & ");"

Many thanks

pH

Glad you got it going .. you are welcome .. (IMG:http://www.utteraccess.com/forum/style_emoticons/default/wink.gif)

RDH