I can't seem to do a SQL query or a recordset.find if a name has an apostrophe. Example:
If the name selected in the listbox has an apostrophe (O'Connor, O'Donald, etc.) then I get an error since there are a total of 3 apostrophes in the Find statement. Is there any way around this? I've tried using brackets to no success. Thanks.
Code:
rs.Find "Name='" & lstFullName.List(i) & "'"
If the name selected in the listbox has an apostrophe (O'Connor, O'Donald, etc.) then I get an error since there are a total of 3 apostrophes in the Find statement. Is there any way around this? I've tried using brackets to no success. Thanks.