title: Update a table via a Form with Data from Inputs on the Form and from another table
body: <p>being new to coding I have run into a wall. I am attempting to update a table &quot;Data_Tbl&quot; from a Form &quot;Form1&quot; with inputs, and a value from a second table &quot;Temp_Tbl&quot; (Which contains predetermined temperature data) based on a Temperature keyed into a field on the Form. My &quot;Temp_Tbl&quot; has 2 fields &quot;Temp&quot; and &quot;TDS&quot; while the &quot;Data_Tbl&quot; has 3 fields to gather data from the form and &quot;Temp_Tbl&quot;,  &quot;Serial&quot;, &quot;Temp&quot; and &quot;TDS&quot;.  I would like to populate the &quot;TDS in the &quot;Data_Tbl&quot; from the &quot;Temp_Tbl&quot; based on the &quot;Temp&quot; keyed into the &quot;Form1&quot; and send it to the table &quot;Data_Tbl&quot; I have attempted to use the answers put forth in this site but to no avail. All I get are errors with the code. I am slightly familiar with VBA.  Any help would be appreciated. I have tried so many things, I don't know what to put as an example.</p>