Reports from a Listbox 1

[johnwiseman]

Hello.

One of our databases has over 100 printable reports each triggered by a button on a form. As you can imagine having over 100 buttons on one page makes for a full page and we have been asked to produce another 25. We dont really want to have multipal forms with buttons.

I have seen databases where the reports are selected from a "list box", so you highlight e.g."report No 5" and use a button which prints it. I cant find anything on the internet on how you attach reports to a list box.

Can anyone help

Thanks in advance.

John

 

[dporrelli]

What I would do is to create another table with your list of forms, then create another form linking to that table.

Then have a sub-form with a scroll box instead of a list box.

I got this template from MS website and i think it has what you are looking for in the reports section.

http://office.microsoft.com/en-gb/templates/TC012186931033.aspx?CategoryID=CT062640421033

 

[rjoubert]

Create your listbox, set the Row Source type to Table/Query, and set the Row Source property to...

SELECT msysobjects.Name, msysobjects.Type FROM msysobjects WHERE (((msysobjects.Type)=-32764));

Then, in the code behind your "Run Report" button, try something like this...

DoCmd.OpenReport Me.lstReports.Value

 

[lars7]

Hi I was looking for something similar and found this, it will need some alteration but it will give you somewhere to start.

thread702-1046082

 

[lars7]

Or use rjoubert's method as it works great

remember to call your listbox "lstReports"