<div>
Thank you for the tips! Will try that or just install the more up-to-date version all together. Will lower the 1,000,000 number.
</div>


Thank you for the tips! Will try that or just install the more up-to-date version all together. Will lower the 1,000,000 number.

<div>
<div class="content wysiwyg-content">
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.<br />
<br />
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 &quot;Don't display lists when more than this number of records is read is set to 1000000.<br />
<br />
The sub form is based off of a query and we haven't done any VBA coding. <br />
<br />
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?<br />
<br />
Thanks in advance!<br />
Aaron
</div>
</div>


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!
Aaron

Filtering - Sub Forms Access 2007

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.