title: Search value in MS Access from textbox
body: <p>I am trying to get record from my table in Access against the value i have entered in my Form</p>
  
  <p>I have a form with a textbox and a button ,on button press it executes a query</p>
  
  <p>query is : </p>
  
  <pre><code>                SELECT *FROM Items WHERE (((Items.ItemName)=lmap));
  </code></pre>
  
  <p>but i want to get only those items which name i entered in my textbox ,for that what should i write instead of lamp, </p>
  
  <p>my textbox name is text1</p>
  
  <p>i tried </p>
  
  <pre><code>                 SELECT *FROM Items WHERE (((Items.ItemName)=&amp;text1));
  </code></pre>
  
  <p>but its not working </p>
  
  <p>any suggestions 
  thanks </p>