Access 2010 filter by form adding extra fields to query

We just upgraded our office from Office 2007 to Office 2010.

We have an internal Access database that we use pretty frequently. Several of our users use the Filter by Form functionality often.

Ever since we upgraded to Office 2010, they have not been able to use the Filter by Form feature.

If I click on Home->Advanced(in the Sort & Filter section)->Clear all Filters, and then click Home->Advanced->Filter By Form, and populate any field on the enti开发者_开发百科re form with whatever I want to filter by, and then I hit Toggle Filter.

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."

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 "<>False And <>False And <>False And <>False". If I delete this extra Field, and hit Toggle Filter, the filter works correctly.

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.

Thanks,

Jeremiah

A search on "Access 'field named zero' OR 'field named 0'" turns up a few experiences that are conceivably related to yours.

Decompiling is a trouble shooting step that can always be recommended, and fixes all sorts of oddities. See http://www.groupacg.com/ACodeTip.htm#DECOMP.