Record not updating (1 Viewer)

[violentjay25]

I am trying to update records. Access says its updated but the changes never take. Can anyone see an issue with my code



DoCmd.RunSQL "UPDATE tbl_Projects " & _
"SET ProjectName = "" & Me.cboProjectName & "", " & _
" SystemsImpacted = "" & Me.TxtSystemsImpacted & "", " & _
" SPRNum = "" & Me.txtSPR & "", " & _
" ReleaseDate = "" & Me.txtReleaseDate & "", " & _
" Status = "" & Me.CboStatus & "", " & _
" CSIPM = "" & Me.txtCSI & "", " & _
" BPM = "" & Me.txtBPM & "", " & _
" Implemented = "" & Me.cboImplemented & "", " & _
" StakeHolder = "" & Me.cboStakeholder & "", " & _
" IBR1 = "" & Me.cboIBR1 & "", " & _
" IBR2 = "" & Me.cboIBR2 & "", " & _
" IBR3 = "" & Me.cboIBR3 & "", " & _
" Objective = "" & Me.txtObjective & "", " & _
" SMERequirments = "" & Me.txtSMERequirements & "", " & _
" Phase = "" & Me.cboPhase & "" " & _
"Where ProjectName = ' & Me.cboProjectName & '"

 

[pbaldy]

For one thing, this is not going to do what you expect:

"Where ProjectName = ' & Me.cboProjectName & '"

It's usually easier to put the SQL into a string variable, since you can then do a message box or Debug.Print and see the results all the concatenation. I'd recommend that here, since I see a couple of things that might not work as expected.