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.