VB Code:
  1. StatSql = "INSERT INTO [Status] ([status], [description], [tool number], [date]) " & _
  2.        "Values ('" & cmbStatus.Text & "', '" & txtDesc.Text & "', '" & ToolID & "', '" & Date & "')"
  3.  
  4. ToSQL = "INSERT INTO [Tool Data]([Tool Number],[Drawing Number],[Type of Tool], [Die Type], " & _
  5.         "[Date Created],[Vendor], [Department], [Tool Number assigned by],[PSketch],[Storage Location], [PMType]) " & _
  6.         VALUES('" & txtNum.Text & "', '" & txtDrNum.Text & "', '" & cmbTType.Text & "', '" & txtDie.Text & "', '" & _
  7.                & txtDate.Text & "', '" & cmbVendor.Text & "', '" & cmbDepart.Text& "', '" & txtAssign.Text & "', '" & _
  8.                & txtSketch.Text & "', '" & txtStore.Text & "', '" & txtPMType.Text & "')"
those are my insert statements but the bottom one is in red do you know why?