eddyzhuo
01-20-2012, 01:51 PM
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. :confused:
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!
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!