title: Access Me.Filter stopped working
body: <p>I have a realy strange problem with a filter in Access 2010.
  The filter worked great for the past days but today I noticed it stopped working (filters out everything) it's a pretty simple Me.Filter. I resetted the VBA code to a state where I know it was working but it still refuses to work as expected. this is an example filter that I am using:</p>
  
  <pre><code>Me.Filter = (Hersteller LIKE '*Test*' OR ID LIKE '*Test*' OR Typ LIKE '*Test*' OR Nennmaß LIKE '*Test*' OR Herstellertyp LIKE '*Test*') AND Status = 'Einsetzbar' AND ID is not null
  </code></pre>
  
  <p>Of course it's activated afterwards <code>Me.FilterOn = True</code> </p>
  
  <p>Seeing that I tried the my old working code it must be something that I changed in the form or the backend table. Unfortunatly I didn't change anything that I can imagin having an impact on filtering. Column names etc. are the same... What makes it wierder is that my date filter <code>Me.Filter = (Datum &gt; #01/18/2015#) OR (Datum &gt; #01/18/2015#)</code> works perfectly. Any idea would be appreciated!!</p>