NEW sql update HELP :( (time field problem)

[ducthang88]

dim update as string
update = "Update borrowedbooks Set Fine = '" & Me!Text39 & "' Where Title = '" & Me!Title & "' And Dateborrowed = '" & Me!Dateborrowed & "'"
CurrentDb.Execute update, dbFailOnError



i always get data type mismatch in criteria expression...


I want is to update the borrowedbooks table and set the fine the same as my text39(text) in the current form where the title is the same as the title(text) in my current form AND where the dateborrowed is the same as my dateborrowed(date) in my form..

[pbaldy]

Date/time field values need to surrounded by # rather than '.