Quick filter in datasheet is missing
Today I stumbled upon a possible answer for you. Try this option:
Menu File → Options... → Filter lookup options for <your DB name> Database
Change the option Don't display lists when more than this number of records is read: from 1000 (the default) to some larger number suiting your needs.
- Go to "Options"
- Find "Current Database"
- Scroll down until you find "Filter Lookup options for {.... your file name...}. It will show the list, and it doesn't allow you to do any filter if your data entry over 1,000. You just select ODBC fields and set the entry as you wish, for example, 2,000.
That's all.
The form's data source query had a filter parameter set which was causing recursive filtering. When I remove that filter ( as it was of no use) it worked well. It was like a logical error which created that issue.