Call log - need help

visual_basic

#1

Can someone please tell me where I'm going wrong with my code? Making a Call log for an OOH office keeps saying that my insert into section is wrong. Would really appreciate the help

Private Sub cmdAdd_Click()
    'Database Display
    CurrentDb.Execute "INSERT INTO OOH_ISSUE_LOG(ID, Locality, Supervisor, DCW, Client_Name, [DateTime], Issue, Action_Required, Action_Complete) " & _
    " VALUES('" & Me.txtID & "','" & Me.cboLocality & "','" & Me.cboSupervisor & "','" & Me.txtDCW & "','" & Me.txtClientName & "',#" & Me.[txtDateTime] & "#,'" & Me.txtIssue & "','" & Me.cboRequired & "','" & Me.cboComplete & "')"
    
    'Sub Form Display
    frmOOH_ISSUE_LOG_SUB.Form.Requery
    
End Sub