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-filter-continuous-form/ 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.