sql UPDATE syntax help

[ducthang88]

Dim strSQL As String
strSQL = "Update books Set AvailableCopies = ' & Me.Text46 & ' Where Title = ' & Me.Title & '"
CurrentDb.Execute strSQL, dbFailOnError




please tweak my shitty code...

update to table books then set the AvailableCopies field the same as the Text46 in my form now Where Title field is the same on the the title field on my form...

[pbaldy]

Presuming the first is numeric and the second is text:

strSQL = "Update books Set AvailableCopies = " & Me.Text46 & " Where Title = '" & Me.Title & "'"