Update query headake

[PuddinPie]

Hello,

I'm trying to run an UPDATE SQL query and keep getting syntax error's. Would someone be able to tell me what I am doing wrong.

"UPDATE tblAllRequestData SET " & _
"tblAllRequestData.RequestersName = '" & Me.txtReqName & "', " & _
"tblAllRequestData.RequestersPhoneNumber = '" & Me.txtReqPhone & "', " & _
"tblAllRequestData.RequestersLLID = '" & Me.txtReqLLID & "', " & _
"tblAllRequestData.RequestersEmail = '" & Me.txtReqLLID & "', " & _
"tblAllRequestData.EMPFirstName = '" & Me.txtEMPFirstName & "', " & _
"tblAllRequestData.EMPLastName = '" & Me.txtEMPLastName & "', " & _
"tblAllRequestData.TTNum = '" & Me.txtTicketNumber & "', " & _
"tblAllRequestData.EmpLLID = '" & Me.txtEmpLLID & "', " & _
"tblAllRequestData.EMPNeedsFileShareAccess = '" & Me.txtFileShareAccessNUM & "', " & _
"tblAllRequestData.EmpSoftwareList = '" & strListItem & "', " & _
"tblAllRequestData.EmpSoftwareOtherCHK = '" & Me.chkFileShare & "', " & _
"WHERE TTNum = '" & strTTNum & "'"

I'm getting "error#3144 ; syntax error in UPDATE statement" when I'm trying to run it.

Can anybody see where the error is? I've been trying for about a day now and can't seem to figure it out.


Thank you.

 

[vbaInet]

1. There's a comma before WHERE
2. Are you sure all your fields contain values?
3. Are all your fields actually Text data types?