VBA to update to predefined text where is null

[webisti]

Hi
I do have a vba code where I am saying check if Description is empty (null) in the query (some items might have empty description but not that many) then insert this text.

strSQL = "UPDATE booklet_list SET booklet_list.descr = ' book sold ' where booklet_list.descr is null "
CurrentDb.Execute (strSQL)

but is not working
where is my error?

thanks for your inputs

Webisti



SOLVED...MISSING THE END

;

[June7]

Interesting, I routinely omit the semi-colon from SQL actions and they run fine. I find the semi-colon is critical to SELECT queries for opening recordset.