I ll like to be able to use a drop down combobox to filter data from a table based on queries.
combobox has values;
I want that when 'Report Pending' is selected from the dropdown, a filter should apply and the table is filtered based on a query like:
select * from TableA where status not in (Complete','Deferred','Cancelled','Delivered). Same idea applies when 'complex reports' is selected from drop down.