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