This may be a bit ambitious but I'm hoping it's something that can be achieved.
On a form I have two combo boxes. In the first the user can select a report. In the second they can select a Department to filter the report by.
What I would like is for the list of departments in that combo box to be restricted to only those that occur in the report that's selected.
So, for example, the user selects Stock report then selects from the full list of departments. But some of the departments may not have any stock, therefore wouldn't appear on the report. I want to be able to have only those departments that do have stock to appear on the drop down.
At present a user has to either download an unfiltered report and view which departments are listed to go back and download the separate reports or select every department to draw down the report regardless of whether there are any records or not.
Hope this makes sense. Let me know if it doesn't
On a form I have two combo boxes. In the first the user can select a report. In the second they can select a Department to filter the report by.
What I would like is for the list of departments in that combo box to be restricted to only those that occur in the report that's selected.
So, for example, the user selects Stock report then selects from the full list of departments. But some of the departments may not have any stock, therefore wouldn't appear on the report. I want to be able to have only those departments that do have stock to appear on the drop down.
At present a user has to either download an unfiltered report and view which departments are listed to go back and download the separate reports or select every department to draw down the report regardless of whether there are any records or not.
Hope this makes sense. Let me know if it doesn't