This project will require many filters, queries and reports for 20 or so different departments. I have a good filter form, but I want to make it easy for the users to find and open the right queries and reports. My general idea is to create a table of query and report object links and let users select and open them using combo boxes, like so:
Is there a way to put a hot link to each object in the combo box (table), or do I need to write some code to execute each one? Do I need to use different methods for each type of object? Can I declare the selected objects as a variable and execute each one the same way?