No field dropdown for table in form window
Posted on 2014-09-09
This question is regrading the manual Column filters available in Access Tables or tables in subforms.
A user had recently asked me how I could fix a issue where the manual column filters of a subform has stopped displaying the filter values dropdowns for checkboxes and other field properties. Normally in view mode the column filters for a table, has a bottom right option on sorting and text/number filters.
(1) I fixed an issue with a simple table where the main table property -subdatasheet had to be set to [None] to enable the display above options.
(2) For a subform which displays some of the columns on the table above, the manual column filter dropdown is not avaialble regardless. Do you know the reason why this is the case and is this a Access DB rule?