title: Refresh MS Access Form/Query Based On Combobox Value
body: <p>Pretty simple explanation. I have a table with 10 entries, 5 entries with the year 2010 and 5 entries with 2011 in a column.</p>
  
  <p>In the query I have, I use Like *2010 to filter out all entries equal 2010 and display onl those records.</p>
  
  <p>On my form, I have combobox being populated with each unique year (from a different table). So my combobox values are 2010 and 2011.</p>
  
  <p>Is it possible, when I select say 2011, I trim the right 4 characters and use as my Like criteria to refresh and requery the form, all done within VBA?</p>