using apostrophe in drop down combo box
Posted on 2010-09-16
I have a form that has a combo box to filter records. The drop down is easy:
SELECT DISTINCT tblRateAgreements.[Firm Name]
The user just starts typing the name, or scrolls down to the name they are looking for. However, when I have a name that contains an apostrophe, like Cozen O'Connor, I get the following error message. Is there a way to accommodate for apostrophe's?
Run-time error '3075':
Syntax error (missing operaot) in query expression '[FirmName]='Cozen O'Connor".