title: Get a text value from a form in Access using a VBA module
body: <p>I currently want to get a value from a form to set it in an SQL query I make in a module under Access using VBA. I tried to use </p>
  
  <pre><code>value = Forms![NameOfForm]![NameOfTextbox] 
  
  sqlquery = "...." &amp; value &amp; "....."
  </code></pre>
  
  <p>It make an error (2450) saying it cannot found the specified form. How can I get the value of this textbox so I could use it in my module?</p>
  
  <p>Thx</p>