Drop down menu for queries and reports

[chris0309 via AccessMonster.com]

Hi All,

Ive created a form displaying butons that open different reports. However I
have a lot of reports and there is far to many buttons on one page. Is it
possible to have a drop down menu that will list all reports allowing the
user to choose one to open?

Thats for any help,

Chris

 

[Duane Hookom]

You can get a list of all the reports from the msysObjects table like:
SELECT MsysObjects.Name
FROM MsysObjects
WHERE (((MsysObjects.Type)=-32764));
IMHO, this is not desireable since it includes subreports and displays names
that I don't intend for users to see.

I would change the above query into a make table query and base the drop
down on the table where I can control the displayed report name and remove
subreports.

SELECT [Name] AS rptName, [Name] AS rptTitle, True AS rptActive INTO
ztblReports
FROM MsysObjects
WHERE [Type]=-32764;