Run-time error '3075':

Syntax error (missing operator) in query expression
'DIRECT_RPTS.COWORKER_LAN_ID = dbo_VergenceUsernameMap.ID 
INNER JOIN MSAUDIT_REMOVED_USER_LOG ON
DIRECT_RPTS.COWORKER_LAN_ID =
MSAUDIT_REMOVED_USER_LOG.R_LAN_ID LEFT JOIN
VP_MAAR_EMP ON dbo_VergenceUsernameMap.EmployeeNo =
VP_MAAR_EMP.EMPLOYEE'.

Query as it currently is, running successfully, but without the new criteria I need to add:

InsertSQL = "INSERT INTO TEMP_DIRECT_RPTS ( MGR_LAN_ID, COWORKER_LAN_ID, COWORKER_LAST_NAME, COWORKER_FIRST_NAME, " _
    & "DATE_INSERTED, USERACCOUNTCONTROL, EMAIL, COMPANY, DEPARTMENT, ACCOUNT_ACTIVE, LOCATION, CITY, STATE, " _
    & "TITLE, EMP_STATUS )" _
    & "SELECT DIRECT_RPTS.MGR_LAN_ID, DIRECT_RPTS.COWORKER_LAN_ID, DIRECT_RPTS.COWORKER_LAST_NAME, " _
    & "DIRECT_RPTS.COWORKER_FIRST_NAME, DIRECT_RPTS.DATE_INSERTED, DIRECT_RPTS.USERACCOUNTCONTROL, " _
    & "DIRECT_RPTS.EMAIL, DIRECT_RPTS.COMPANY, DIRECT_RPTS.DEPARTMENT, DIRECT_RPTS.ACCOUNT_ACTIVE, " _
    & "DIRECT_RPTS.LOCATION, DIRECT_RPTS.CITY, DIRECT_RPTS.STATE, DIRECT_RPTS.TITLE, VP_MAAR_EMP.EMP_STATUS " _
    & "FROM (DIRECT_RPTS LEFT JOIN dbo_VergenceUsernameMap ON DIRECT_RPTS.COWORKER_LAN_ID = dbo_VergenceUsernameMap.ID) " _
    & "LEFT JOIN VP_MAAR_EMP ON dbo_VergenceUsernameMap.EmployeeNo = VP_MAAR_EMP.EMPLOYEE " _
    & "WHERE (((DIRECT_RPTS.MGR_LAN_ID)='" & User & "') AND ((VP_MAAR_EMP.EMP_STATUS) Not In ('TF','TP','SN')))"


Changes I am trying to make to add table MSAUDIT_REMOVED_USER_LOG, so that if COWORKER_LAN_ID is found in this table 
(as R_LAN_ID), that record will not be inserted into TEMP_DIRECT_RPTS:

InsertSQL = "INSERT INTO TEMP_DIRECT_RPTS ( MGR_LAN_ID, COWORKER_LAN_ID, COWORKER_LAST_NAME, COWORKER_FIRST_NAME, " _
    & "DATE_INSERTED, USERACCOUNTCONTROL, EMAIL, COMPANY, DEPARTMENT, ACCOUNT_ACTIVE, LOCATION, CITY, STATE, " _
    & "TITLE, EMP_STATUS )" _
    & "SELECT DIRECT_RPTS.MGR_LAN_ID, DIRECT_RPTS.COWORKER_LAN_ID, DIRECT_RPTS.COWORKER_LAST_NAME, " _
    & "DIRECT_RPTS.COWORKER_FIRST_NAME, DIRECT_RPTS.DATE_INSERTED, DIRECT_RPTS.USERACCOUNTCONTROL, " _
    & "DIRECT_RPTS.EMAIL, DIRECT_RPTS.COMPANY, DIRECT_RPTS.DEPARTMENT, DIRECT_RPTS.ACCOUNT_ACTIVE, " _
    & "DIRECT_RPTS.LOCATION, DIRECT_RPTS.CITY, DIRECT_RPTS.STATE, DIRECT_RPTS.TITLE, VP_MAAR_EMP.EMP_STATUS " _
    & "FROM (DIRECT_RPTS LEFT JOIN dbo_VergenceUsernameMap ON DIRECT_RPTS.COWORKER_LAN_ID = dbo_VergenceUsernameMap.ID) " _
    & "INNER JOIN MSAUDIT_REMOVED_USER_LOG ON DIRECT_RPTS.COWORKER_LAN_ID = MSAUDIT_REMOVED_USER_LOG.R_LAN_ID  " _
    & "LEFT JOIN VP_MAAR_EMP ON dbo_VergenceUsernameMap.EmployeeNo = VP_MAAR_EMP.EMPLOYEE " _
    & "WHERE (((DIRECT_RPTS.MGR_LAN_ID)='" & User & "') AND ((VP_MAAR_EMP.EMP_STATUS) Not In ('TF','TP','SN'))) " _
    & "AND DIRECT_RPTS.COWORKER_LAN_ID NOT IN (SELECT R_LAN_ID FROM MSAUDIT_REMOVED_USER_LOG)"