update SQL not working

[gammaman]

I have two update SQL's. The first one is working and the second one is not. Can someone please help me figure out why?

The good one

Set db2 = CurrentDb


strSQL2 = "UPDATE tblJobFamily INNER JOIN tblActiveJCodes ON tblJobFamily.jobcode = tblActiveJCodes.jobcode " & _
           "SET tblJobFamily.JObFamily = tblActiveJCodes.JOB_FAMILY ," & _
               "tblJobFamily.BaseHours = tblActiveJCodes.std_hours ," & _
               "tblJobFamily.JobFunction = tblActiveJCodes.JOB_FUNCTION ," & _
                 "tblJobFamily.EEOC = tblActiveJCodes.XLATLONGNAME ," & _
                 "tblJobFamily.SalaryPlan = tblActiveJCodes.SAL_ADMIN_PLAN ," & _
                  "tblJobFamily.CompFreq = tblActiveJCodes.comp_frequency ," & _
                  "tblJobFamily.FLSA = tblActiveJCodes.flsa_status " & _
          "WHERE tblJobFamily.JobCode = '" & Me.JobCode & "'"


db2.Execute strSQL2, dbFailOnError

The bad one

Set db4 = CurrentDb


strSQL4 = "UPDATE tblJobFamily INNER JOIN tblJobCdMapping ON  tblJobFamily.jobcode = tblJobCdMapping.JOBCODE " & _
          " AND tblJObcodeMapping.SETID = tblJobFamily.Setid " & _
           " SET tblJobFamily.Merit = tblJobCdMapping.[COMP_RATECD] " & _
          " WHERE tblJobFamily.JobCode = '" & Me.JobCode & "' " & _
          " AND tblJobCdMapping.[COMP_RATECD] = 'COMMON';"




db4.Execute strSQL4, dbFailOnError

[ranman256]

have you tried running it as a query?
Queries will give error messages, and debugging is easier.

[gammaman]

As a pass-through query? I have not. i did however use the query builder and the query was successful.

[gammaman]

Never mind. I woodshed(ed) myself.