Filtering - Sub Forms Access 2007
Posted on 2014-01-20
Using Access 2007 in Datasheet View all filters work. In Form view there is a subform and within the A-Z, Z-A and general text filters (equals, contains, etc.) are all there but the check box filters are not.
They do show up for the same database/form in Access 2010 and Access 2013. The fields are all filterable individually and the general filter lookup options are all checked and the "Don't display lists when more than this number of records is read is set to 1000000.
The sub form is based off of a query and we haven't done any VBA coding.
Any general ideas as to why we might not be able to see the check box filters within 2007, but can in later versions? Could it be the query itself that is generating the subform?
Thanks in advance!