docmd.runsql not working

[Rameez]

I regularly use sql statements to update my tables.

I found that docmd.runsql is not working when I put in names with ' in them.



For example
docmd.runsql "UPDATE Director SET Dir_Nme= '" & me.director & "' WHERE Empid=1000;"
fails when the director textbox on my form has a name like O' Malley, Sardina....and passes if it is O Malley, Sardina

!!!!!!!!!!! prob with '...i suppose

[RuralGuy]

That is because you are using the single quote as a string delimiter. Using the double quote as the delimiter has fewer problems.
"UPDATE Director SET Dir_Nme = """ & me.director & """ WHERE Empid=1000;"

[Rameez]

This seems to work but not in all cases...

[RuralGuy]

What case does *not* work correctly?