Datasheet Filter by Column - Similar to Excel - What is that called? 1

[lameid]

A new to me feature using Access 2010...

In data sheet view of a subform, a right click of the column lists possible values that can be checked and unchecked much like the filter feature in Excel.

First what is this called so I can talk intelligently about it?

Secondly or what I really need to know... Why does it not appear on one of my datasheet subforms and not the other?

 

[lameid]

Oops...

It is not a right click it is a click of the down arrow at the top of the column... Apparently it is Text filters.... and my list does not show values on one form.

 

[lameid]

So if in Access your filter check list is missing from the datasheet view for the feature like Excel's Autofilter function (ultimately how I searched and found the nudge in the right direction).

Look under...
File, Options, Under "Filter Lookup Options for <database Name>"

In my case I had to check "ODBC fields".
At some point it may be necessary to change the "Don't display lists when more than this number of records is read:" if I still need to show the values.

In my case, it worked on one form because it was based on a SQL Pass Through query while the broken one is based on linked ODBC tables.

Hopefully I have hit all the possible key words for the next poor soul to find this... Feel free to dogpile them on :-D