Multiselect Filter in a Continuous Form
Unlike datasheet forms, continuous forms do not have a multiselect filter option.
This video shows how the feature can easily be added, either from the user interface or using VBA code (2 methods).
For more info, see my article: https://isladogs.co.uk/multiselect-fi...
TIMES:
0:00 Intro
0:28 Multiselect filter explained - built-in to datasheets but NOT continuous forms
0:44 Multiselect filter feature can be added to continuous forms via the user interface or using code
1:20 DEMO -starting with datasheet to show full filtering functionality with no additional code
1:39 Datasheet - right click context menu with sorting & wide range of filter menus
2:04 Datasheet - click on header label dropdown to show multiselect filter checkboxes
3:00 Multiselect filter may not appear for all fields depending on number of unique records in list
3:43 Test using top 1000 records - multiselect filter appears for ALL fields
4:04 Maximum number of records to be shown in lists is set in Access Options - default = 1000
4:35 Can increase limit but performance may be affected if value set too large
5:12 Continuous forms - similar right click context menu as for datasheet BUT no multiselect filter option
5:41 Common workaround - using checkboxes & command buttons
6:12 Code for workaround method
7:06 No code method using large Filter button in Home ribbon
7:54 Better approach using code in click event of field header and/or double click event of fields
9:20 ... and/or add code to double click event of fields.
Two code methods available DoCmd.RunCommand acCmdFilterMenu OR Application.CommandBars.ExecuteMso ("FiltersMenu")
10:10 Application.CommandBars code works in main form but fails in subform.
11:18 DoCmd.RunCommand code works in all types of form.
11:45 Thanks for watching. Please like, leave a comment & subscribe.