when sql statements are written like what you're doing here, the printout would look like this:
Code:
tblaudit.audEmpName = 'value'
so when there's an apostrophe in the name, the printout would look like:
Code:
tblaudit.audEmpName = 'val'ue'
which obviously is in error (as you can see by the mix-up in the coloring scheme for the 'SQL' tag that I put that statement in! try this first:
Code:
tblaudit.audEmpName = " & """" & c & """" & ", etc...
that will replace those single quotes with doubles. I (think) that'll solve the problem, because singles inside doubles are ignored in terms of their intended meaning to visual basic. As in - the single quotes become string "characters" instead of string indicators.