What is the proper syntax to include the actual Error Msg into a Memo via an Update query.
Here is what I have so far:
strSQL2 = "UPDATE tblAPList SET Active = No, Failed = Yes, ErrMsg = Err.Number & ' ( '& Err.Description & ')' " & _
" WHERE tblAPList.ApNo= '" & gApNo & "'"
Getting syntax error msg