Im am using textboxes bound to my database using DAO. I am using a query based on the information in the textbox. My problem is that when an apostrophe is entered in the box I get an error. I understand its because the apostrophe is messing up the SQL query syntax. Is there anyway around this so I can enble users to enter apostrophes.

Help would be appreciated, thanks,
Wick