3075 error

[abzalali]

Dear Expert,
Getting 3075 syntax error to insert current date:

        DoCmd.RunSQL "UPDATE tblTransactionsDetail " & _
             "SET tblTransactionsDetail.ReceivedDate = " & todaysDate & ", tblTransactionsDetail.Received = 'Yes'" & _
             "WHERE (((tblTransactionsDetail.TranDetailID) = " & Me.TranDetailID & "))"

Please help me.

Thanks
Mir

 

[Cronk]

.... SET tblTransactionsDetail.ReceivedDate = #" & Format(todaysDate,"mm/dd/yyyy) & "#, ....