title: How to limit a drop down list in a combo box to only show the values that include the letters that the user typed?
body: <p>I am using Access 2010 database. I have a combo box that gives me a full list of equipment numbers (they have letters and numbers i.e.: sdp1234). </p>
  
  <p>To try to speed up the database I was told to limit the drop down lists in combo boxes.</p>
  
  <p>Currently, users can start typing the equipment # and an item from the list will be highlighted matching with their typed characters.</p>
  
  <p>I want the users to be able to type "12" and the list show should have only the values between "sdp1200" and "sdp1299". Or even just all the items that have "12" inside.</p>
  
  <p>I am not sure if this is done in VBA or in the properties tab for the combo box.</p>