Printing reports off a list box

[kbandong1]

I'm trying to show a print preview of reports that I have made. I was originally going to make separate command buttons to do so but I have too many reports. I wanted to use a list box and have a command button bring up the preview of the report I want. I'm having trouble setting it up. Do I need to create a macro for this or is there a way of linking the list box with the reports on click with a command button?



The reports are basically linked to queries that generate a list once I create the record on my main form. I just need some direction from that point on what to put on my form so I can avoid creating multiple command boxes.

[ajetrumpet]

I don't understand this. What is the listbox for? What's in it? filter criteria for these reports? report names? That would be helpful here.

[kbandong1]

I've attached my database along with this reply. I accidentally omitted the list box I wanted to use. Basically, this db is for my dvd collection and I wanted a way to link the reports to my main from to open up a print preview of a report I choose. The reports are broken down to genres (ie: Action, Comedy, etc.) Those reports are linked to queries with filter criteria separating the genres and creating a list of the certain genre that would fulfill the criteria (ie: if the report I wanted was from the "Action" genre, my query "qryAction" would be implemented and the criteria of that query is "Action" from my main table named tblMain).

Simply put, I want to avoid using multiple command buttons that will show me a preview of 1 of the 18 reports and use a list box that has all the genres and use one command button to show me a preview off that list box of genres.

I have not created all the reports but some just to clarify on what will show up when it's fully completed. I have some reports on the main table (tblMain) just as a test to see if my queries are working properly.

[Access_Blaster]

Bob Larson has an example of a listbox previewing and printing reports here. Look near the botton of the page.