title: Access 2010 filter by form adding extra fields to query
body: <p>We just upgraded our office from Office 2007 to Office 2010.</p>
  
  <p>We have an internal Access database that we use pretty frequently. Several of our users use the Filter by Form functionality often.</p>
  
  <p>Ever since we upgraded to Office 2010, they have not been able to use the Filter by Form feature.</p>
  
  <p>If I click on Home->Advanced(in the Sort &amp; Filter section)->Clear all Filters, and then click Home->Advanced->Filter By Form, and populate any field on the entire form with whatever I want to filter by, and then I hit Toggle Filter.</p>
  
  <p>I get a blank form back, and with an ID of (New). If I try to move forward or backward a record, I get an error that says "You can't go to the specified record."</p>
  
  <p>So, I went to Home->Advanced->Advanced Filter/Sort, and this loaded a query. The query looks correct, but there is an additional Field, named 0, with a Criteria of "&lt;>False And &lt;>False And &lt;>False And &lt;>False". If I delete this extra Field, and hit Toggle Filter, the filter works correctly.</p>
  
  <p>This is happening consistently on all 5 computers in the office, and on any form in the database. Any help or suggestions would be greatly appreciated.</p>
  
  <p>Thanks,</p>
  
  <p>Jeremiah</p>