I have an ACCESS program that generates an error when the event name contains a single quote. For example, 2013 X'mas party will cause an error where as 2013 Xmas part will not error.
Here is the code:
Set db = CurrentDb()
Set Rst = db.OpenRecordset("Events", dbOpenDynaset)
Rst.FindFirst "[Event_Name] = '" & Me!Event_Name & "'" <----- stops here
Can you help?