title: MS Access: How to get value of textbox on button click?
body: <p>This is a complete newbie question, but I couldn't find any solution online (at least nothing to my understanding). I want to make a form with a textbox and a button and on click, the button should take the value written in the textbox, find the row with that ID in a table and change an attribute to <code>unavailable</code>. Normally I would do this with a simple SQL statement:</p>
  
  <pre><code>UPDATE table SET available='NO' WHERE id = *textbox.value*;
  </code></pre>
  
  <p>What should I write instead of textbox.value so that it works?</p>