Hi all, need help with my memory. There is a way to filter a table control by way of a listbox where on opening the form the list either shows a blank or resulting in the tablecontrol being unfiltered, once a listbox item is selected and refreshed the table control adjusts accordingly.
Is that done using coalesce as part of the sql statement in the listbox?
Thanks
Hello,
Showing all or selective is simply selection in the SQL where the filter table item is NULL. See this post → Base: Conditional Query. How to filter with a ListBox and add ALL?
Your question adds a second condition - open form with “All”. This needs a macro. Since the filter table is the determining factor, on opening the form run an SQL macro to set the filter to desired value.