Drop Down Menu For Reports

[Herdrich]

I am trying to make a drop down box so that a user could select what report they wanted insted of searching through large amounts of buttons. I have about 500 reports and do not want to have each of them attached to a button like i have started to do. I want to be able to just select what report is needed from a drop down box. Thank you for your time.

~Glenn

 

[dhookom]

I would use a couple cascading combo or list boxes. Consider categorizing the reports so the first "box" can filter the display of reports in the second "box". This solution suggests you create tables of reports and report categories.

Duane
Hook'D on Access
MS Access MVP

 

[Herdrich]

I figured out how to get all of the reports into a list box by using the information from this website

http://allenbrowne.com/ser-19.html

but i cannot get it to open the chosen report. They are all there but when i click on them it dose nothing. Any one have an idea on what i may be missing.

Thanks
~Glenn

 

[Herdrich]

I used the first method on that page. Is there a way that i could use a button with a macro that opens whatever report is chosen in the list box.

 

[dhookom]

Allen's code is good but you will see subreports in your list and IMO users shouldn't see my report names which are like: rptEmpVacDays or rptEmpWorkSchedule. I would take the time to create tables of reports and categories with report titles to display rather than report names.

You need code on the command button click event like:

   If Not IsNull(Me.lboReports) Then
      DoCmd.OpenReport Me.lboReports, acPreview
    Else
      MsgBox "Select a report and try again", vbOkOnly, "PEBKAC"
   End If

Duane
Hook'D on Access
MS Access MVP

 

[Herdrich]

Thanks for the help. I would want to create tables but with the amount of information that i have and the short time i have to get a runnuing copy issent going to work but it will surly be an update once everything is running.

Thanks again