title: Runtime error 3075 can't figure it out
body: <p>I'm trying to do an insert on a button click event and I keep getting a runtime error of missing operator in query expression my query looks like the following. Any ideas?</p>
  
  <pre><code>Private Sub CmdAdd_Click()
  Dim strSql As String
  
  strSql = "INSERT INTO Current_Costs(PO_Number,Lineitemid,Capital_detail,CapitalID,GL_Number,Cost_Type,Cost_Center,Cost_cat,Item_Cost,PO_Date)" &amp; _
  " VALUES (" &amp; Me.txtPONum &amp; "','" &amp; _
      Me.cmbCapDetail &amp; "','" &amp; _
      Me.cmbCapDetail.Column(1) &amp; "','" &amp; _
      Me.txtCapID &amp; "','" &amp; _
      Me.txtGLNum &amp; "','" &amp; _
      Me.cmbCostType &amp; "','" &amp; _
      Me.txtCostCen &amp; "','" &amp; _
      Me.cmbCostCat &amp; "','" &amp; _
      Me.txtCost &amp; "','" &amp; _
      Me.TxtPODate &amp; "')"
  
     DoCmd.RunSQL strSql
  </code></pre>
  
  <p>i have a similar query that has the same issue and i cant see the problem</p>
  
  <pre><code> CurrentDb.Execute ("UPDATE Current_Costs " &amp; _
      "SET PO_Number='" &amp; Me.txtPONum &amp; "'" &amp; _
      ",Lineitemid='" &amp; Me.cmbCapDetail &amp; "'" &amp; _
      ",Capital_detail='" &amp; Me.cmbCapDetail.Column(1) &amp; "'" &amp; _
      ",CapitalID='" &amp; Me.txtCapID &amp; "'" &amp; _
      ",GL_Number='" &amp; Me.txtGLNum &amp; "'" &amp; _
      ",Cost_Type='" &amp; Me.cmbCostType &amp; "'" &amp; _
      ",Cost_Center='" &amp; Me.txtCostCen &amp; "'" &amp; _
      ",Cost_cat='" &amp; Me.cmbCostCat &amp; "'" &amp; _
      ",Item_Cost='" &amp; Me.txtCost &amp; "'" &amp; _
      ",PO_Date='" &amp; Me.TxtPODate &amp; "'" &amp; _
      "WHERE LineItemPOID=" &amp; Me.txtID.Tag)
  </code></pre>
  
  <p>edit solved</p>