Filtering - Sub Forms Access 2007

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
aaron248Asked:
Who is Participating?
 
PatHartmanConnect With a Mentor Commented:
I think it was an oversight in A2007 that has since been corrected.  I believe that was the first version of Access that offered this type of filtering and they might not have included checkboxes.

If this feature is important to you, distribute the A2010 or A2013 runtime for your users to use rather than A2007.  This is an interface issue so you won't have to change the development platform unless you want to.

PS 1,000,000 is way too large a number for a combo.
0
 
aaron248Author Commented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.