Run SQL don not update

[starclassic]

Here's my sql statement to update yes/No and date where IndexID(primary key) is the current record selected.

DoCmd.RunSQL "UPDATE tblCreditDetails SET tblCreditDetails.ysnSentByMailToStaff = -1, tblCreditDetails.dteFUDate = Date() WHERE (tblCreditDetails.IndexID = '" & Me!txtIndexID1 & "')"

But will not update.

 

[Ed2020]

Do you get an error message?

Ed Metcalfe.

Please do not feed the trolls.....

 

[Crowley16]

try using now() instead of date()

and check the value of Me!txtIndexID1, you've got string delimiters in there, so is tblCreditDetails.IndexID a string datatype?

--------------------
Procrastinate Now!

 

[starclassic]

IndexID is a Primary and its a Autonumber

 

[starclassic]

I got it working now... Thanks everyone.

 

[starclassic]

Here's the final SQL statement
DoCmd.RunSQL "UPDATE tblCreditDetails SET tblCreditDetails.ysnSentByMailToStaff = -1, tblCreditDetails.dteFUDate = Date() WHERE tblCreditDetails.IndexID = " & CStr(Me.txtIndexID1)