apostrophe in string index's

[wjburke2]

I have a screen that has three fields Category, Campaign, CamType these three fields are a unique index for a table. I query the table to ensure the user entered a unique value before I try to update the table. I get this error.

strFilter = "CatId = '" & Me!txtCategory & _
"' AND Campaign = '" & Me!txtCampaign & _
"' AND CamType = '" & Me!txtCamType & "'"
strCam = DLookup("Campaign", "Campaign", strFilter

Syntax error (missing opertor) in query expresion 'CatId = 'CAT-1' AND Campaign = 'ADB' AND CamType = 'Jim's"

Is there a way to strip out the apostrophe, or is there a better way that will allow them to keep the apostrope?

 

[dkinley]

Dealing with apostrophes is always a troublesome issue. I think that Access and SQL handle them differently - one uses them to denote the end of a string.

I've always used the following link to help me keep them straight ...

http://msdn.microsoft.com/en-us/library/aa212167(office.11).aspx

-dK

 

[wjburke2]

Thanks for your input dkinley. I found the answer on another forum. It was an easy fix.

Me.txtCamType = Replace(Me.txtCamType, "'", "")

 

[dkinley]

You bet. Thanks for posting the final resolution back.

-dK