title: Updating tables in VBA ACCESS
body: <p>i need help solving my problem with vba update statement:</p>
  
  <p>In my form i have a click form that when i click it execute this procedure :</p>
  
  <pre><code>Dim strSQL As String
   Dim rst As New ADODB.Recordset
  
    strSQL = "UPDATE dbo.Firma_test SET Fax = " &amp; Me![subforma_companie].Form!fax &amp; _
            "[E-mail] = " &amp; Me![subforma_companie].Form!email &amp; _
            "WHERE Company_Code = " &amp; Me![subforma_companie].Form!Cod
  </code></pre>
  
  <p>When i execute i tell me that he didn't see the email field, what can i do???</p>