Hello every expert out there, 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!

db.Execute ("UPDATE Candidate SET CHECKED = NULL WHERE ID=" & Chr(34) & [Form Data].Candidate_ID.value & Chr(34) & " AND SESSION=" & Chr(34) & [Form Data].Candidate_SESSION & Chr(34))