title: can't insert value from a form into lookup field
body: <p>I have a form that insert data into a table , the problem is I can't insert value from my combo box into a table field which is ( lookup field) this field should store an integer (ID) that I lookup from a different table.
  the error I have is
  <a href="https://i.stack.imgur.com/167as.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/167as.jpg" alt="enter image description here" /></a></p>
  <p>here is my code :</p>
  <pre><code>DoCmd.RunSQL (&quot;INSERT INTO tblStocks([Stock Code], [Stock Name], [Stock Keeper1]) VALUES('&quot; &amp; txtCode &amp; &quot;','&quot; &amp; txtName &amp; &quot;',&quot; &amp; cmbStockKeeper1.Value &amp; &quot;)&quot;)
  </code></pre>