Selecting a report from a drop down box

[d3cyph3r]

Hi, I'm wanting to consolidate all my reports on to one form. At
present you can set the date range and run the specific report. What
i'm after is the ability to, as well as select the date range to be
able to select which report ro run via a drop down box.

Thanks in advance

 

[Allen Browne]

Here's a couple of solutions:
List Box of Available Reports
at:
http://allenbrowne.com/ser-19.html

 

[Keith Wilby]

Hi, I'm wanting to consolidate all my reports on to one form. At
present you can set the date range and run the specific report. What
i'm after is the ability to, as well as select the date range to be
able to select which report ro run via a drop down box.

Just a slight aside but I find a list box to be much more friendly for
listing reports for the user to choose from.

Keith.
www.keithwilby.co.uk

 

[Duane Hookom]

I use a table of reports to use as the Row Source of a list box. This allows
me to provide the user with a more friendly title as well as additional
information. I don't expect my users to see something like "rptDeptPONums".