I am currently trying to run an update query through VBA Code and I cant seem to get it to work, Don't know if theres just a slight error or I'm miles off.
any suggestions?
Code:
Dim db As DAO.Database, sSQL As String
Set db = CurrentDb
sSQL = "UPDATE [Job Detail] SET [StatusID] = 5 " & _
" WHERE [Document Name] = '" & Me.[Document Name] & "' AND [Job Complete] = 0"
db.Execute strSQL, dbFailOnError