Following on from this thead (thanks again Alan it worked perfectly ), I've had an idea!
Is it possible to populate a listbox with the list of all reports in the current database, that start with a certain prefix? (eg rptATT_<reportname>)?
Reason being, is I have a "reports control panel" which I have some report names listed down the left-hand side of the screen, these are currently check boxes with a description, then in the tag I have the name of the report to open. The control panel also has a date range and output method, where the user can select either "print", "preview", can export to excel, or can export to PDF. This also works brilliantly for multiple reports, as the system just combines the reports (if excel or pdf is selected) into a single file before doing something with it. (will add this into the code archive if there's enough of a demand for it)
However, the biggest current flaw in the design is that if I add any new reports in I will need to change the form design, adding in a new checkbox for the report - so I thought, why not just pull the details through automatically from the system?
Any ideas? Has anyone done anything like this?