Menu
I have a subform in datasheet view mode and it has missing the filter option that generally appear with checkboxes.
Missing
By qick filter and checkboxes for filter I mean this:
Can somebody tell me how can I get that back?
419
On the Home tab, in the Sort & Filter group, click Advanced and then click Advanced Filter/Sort on the shortcut menu. Add the fields on which you want to filter to the grid. In the Criteria row of each field, specify a criterion.
The Datasheet view has built-in filtering and sorting options available when you want to search or filter for specific data. The Datasheet view is also useful for quickly viewing the details of many records, adding new records, and deleting records from a table.
Answer. The utility of filters in datasheet are:-Filtering is a useful way to see only the data that you wanted to be displayed in Access databases. You can use filters to display specific records in a form, report, query, or datasheet, or to print only Certain Records from a Report, table, or Query.
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.
That's all.
183
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.
27
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
