update query in access vba

[thep]

I have an update query but I cant get it to work for some reason.

hope I can find some answer to this.

CurrentDb.Execute "UPDATE TT_PumpInfo SET TT_PumpInfo.UPC = " & Me.txtUPC & " WHERE (((TT_PumpInfo.SerialNo)= " & Me.SerialNo & "));"



this is my query and I keep getting error 3144 syntax error.

[June7]

When constructing SQL in VBA, text fields require apostrophe delimiters for data. Date fields require # delimiter

CurrentDb.Execute "UPDATE TT_PumpInfo SET UPC = '" & Me.txtUPC & "' WHERE SerialNo = '" & Me.SerialNo & "';"