Updating record SQL/VBA

[subtilty]

Hi All,

I am trying to made a button to update the fields on my form.

I developed this but I am guessing it's wrong as getting a 3075 error on it.



Any help would be great please

CurrentDb.Execute "UPDATE calldata " _& "SET username =  & Me.username & " ','" & _
& "SET reportdate = Me.reportdate & " ','" & _
& "SET registration = Me.registration & " ','" & _
& "SET vin =  & Me.vin & " ','" & _
& "SET vehmodel =  & Me.vehmodel & " ','" & _
& "SET vehengine =  & Me.vehengine & " ','" & _
& "SET vehfuel =  & Me.vehfuel & " ','" & _
& "SET vehtrans =  & Me.vehtrans & " ','" & _
& "SET custtype =  & Me.custtype & " ','" & _
& "SET custname =  & Me.custname & " ','" & _
& "SET custtel =  & Me.custtel & " ','" & _
& "SET custemail =  & Me.custemail & " ','" & _
& "SET custconcern =  & Me.custconcern & " ','" & _
& "SET cc =  & Me.cc & " ','" & _
& "SET as =  & Me.as & " ','" & _
& "SET centre =  & Me.centre & " ','" & _
& "WHERE reportnumber =  & Me.reportnumber & "')"

[June7]

Missing quote marks, apostrophe and # delimiters missing or in wrong place, space in front of second apostrophes, don't repeat SET, don't double up the &:

CurrentDb.Execute "UPDATE calldata " & _
"SET username = '" & Me.username & "', " & _
"reportdate = #" & Me.reportdate & "#, " & _
"registration = '" & Me.registration & "', " & _
"vin = '" & Me.vin & "', " & _
"vehmodel = '" & Me.vehmodel & "', " & _
"vehengine = '" & Me.vehengine & "', " & _
"vehfuel = '" & Me.vehfuel & "', " & _
"vehtrans = '" & Me.vehtrans & "', " & _
"custtype = '" & Me.custtype & "', " & _
"custname = '" & Me.custname & "', " & _
"custtel = '" & Me.custtel & "', " & _
"custemail = '" & Me.custemail & "', " & _
"custconcern = '" & Me.custconcern & "', " & _
"cc = '" & Me.cc & "', " & _
"as = '" & Me.as & "', " & _
"centre = '" & Me.centre & "', " & _
"WHERE reportnumber = '" & Me.reportnumber & "')"

If any of the fields are number datatype, remove the apostrophes.
Why are you doing this? Are you not using bound form to edit records?