Selecting a report from a drop down box

D

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
 
K

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.
Click to expand...

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
 
D

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".
 
Top