This is the code I have for a find form that searches through a datbase and the user can click click the name shown and the record is populated on the form.frmTable1.Data1.Recordset.FindFirst "[Appname] like '" & frmfind.DBCombo1.Text & "*'"
The only problem is if the record contains an apostrophe and I try to open it ' I get a runtime error....Any help with this one?

PLEASE HELP