Combo box error (1 Viewer)

[ian_ok]

I have a combo box which is used to find a persons details on a form, which works fine **EXCEPT when yet when you select the person who's name has an apostrophe in it, I get a run time error.

Can this be corrected in any way?

Ian

 

[KevinM]

Yes you need to change the criteria in the after update to look something like this...

Me.RecordsetClone.FindFirst "[MyField] = " " " & Me![MyCombo] & " " " "

HTH

[This message has been edited by KevinM (edited 06-08-2001).]