Dynamic Reporting Checkbox Query

Discussion created by oman on Apr 15, 2017
Latest reply on Apr 16, 2017 by philmodjunk

I'd like to create a layout for my database that allows the user to make field selections in the top header and have the list of records below (in list view) dynamically update based on the selections. In other words, as a user selects different field values (a date range, product status, product type) the query would combine the selections and only show records that match all those criteria. And unselecting one would show all the records again without having to select Show All and make selections again. I'd like to use a mix of check boxes and drop down menus.


This would be different than just entering Find Mode, setting all of the search options and then running the query. I want to basically stay in Browse mode and have the database adjust the query on the fly (showing and hiding records) based on what is selected at the top.


Any best practice suggestions or examples would be appreciated.