I an using the Find method to find a surname in an Access table. Everything is OK so long as I do not try to find a surname with an apostrophe in it e.g O'Donnell, O'Neill.
How can I get around this.
Here is an example of my code using the Find method
rstSearch.Find "Surname = '" & sSurnameSearch & "'"