How to set Query Date Value to NULL

[eddyzhuo]

Hello every expert out there, I can not find a correct board. I am trying to update a CHECKED(DATE) field in the access Candidate table to a null value or a empty value or just simple clear the value of the field. I am keep getting a object required error 424.

Here is my code:
db.Execute ("UPDATE Candidate SET CHECKED="" WHERE ID=""" & [Form Data].Candidate_ID.value & """ AND SESSION=""" & [Form Data].Candidate_SESSION & """")

Please advice. Thank you so much!

[eddyzhuo]

Sorry everyone, I figure it out myself. I forget to include db= currentDB; Haha. Have a wonderful day.