Does anybody see anything wrong with this Update query please?

mySQL2="UPDATE Interp rates SET Interp Rates.Next Rate=nextrate WHERE (((F1)='ZAR')and (isnull(F5)=True))"

(The table is [Interp Rates], the field I want to update is [Next Rate], and the set is any record where [F5] is Null and where [F1] is "ZAR".

When it encounters the doCmd runSQL2, it returns "Syntax error in UPDATE statement."

Thanks in advance!
Don

AND F5 IS NULL

Also your Interp rates should be enclosed in brackets as such [Interp rates] since it contains a space, same with Next Rate

Thanks! I knew it was something simple like that. :)