Hi Gene,

That's your problem then. In the following line your building a string that uses single quotes as a delimiter:

...",'" + lcCompanyName + "'"

This would translate to:

'Smith's'

which would cause the problem. You may want to use [square brackets] as your delimeter instead.

>i take that back. that is the field it is in, but why would that cause an error.