title: MS Access 2010 Multi column Combobox Autocomplete
body: <p>I have a simple combobox in Access which serves as a result set holder and contains two columns id and name.</p>
  
  <p>I have developed a simple search feature,
  i.e user types in a keyword in a textbox and the combobox returns the results after searching the substring,</p>
  
  <p>Example:</p>
  
  <p><strong>TXT BOX Input:</strong> App</p>
  
  <p>Combobox Results:</p>
  
  <p><strong>ID Name</strong></p>
  
  <pre><code>1   Cinnamon Apple
  2   Apple Candy Box
  42  Carton of Apples
  54  iphone App
  6   App Store
  </code></pre>
  
  <p>Now when I go to search the combobox box within the results and I type "i", I expect to select "iphone App" from the drop down but nothing happens because it is searching the first column i.e ID</p>
  
  <p>So how can I search for the names and autocomplete the combobox? or search by second column</p>
  
  <p>Also, It is important for me to show the ID, If I hide the ID column I can search by the Name just fine, since it is the only column in the result set.</p>