I have a form that has a combo box to allow users to lookup a record based on a name field. It works fine except if the name field value as an apostrophy - then I generates a syntax error - missing operator. so it finds "Joes Bakeshop" but not "Joe's Bakeshop". The db is access97, and it hangs on the this code:
Me.RecordsetClone.FindFirst "[ApplicantName] = '" & Me![Combo113].Value & "'"
Any ideas?
Thanks!