print open report via print button on the switchboard

[pacarv]

I've created a database in Access 2003 with multiple reports that are accessable from the switchboard. The switchboard also has a print button. The user selects the report from the menu which then opens in another window for the user to preview. I am trying to enable the print button to print the open report however the print macro prints the switchboard instead.

Can anyone provide me with the code needed to accomplish my goal? I have no experience with VBA and little with SQL. My users are not versed in Access so I'd like to make things as simple as possible for them.

Thank you for your time and any help you can provide.

[DonRayner]

Set the focus to the report before you do the print command. Replace MyListBox with whatever the name of your listbox is.

Dim ReportName as string
ReportName = Me.MyListBox
DoCmd.SelectObject acReport, ReportName, False
DoCmd.PrintOutut
 

You will also need to either add some code to check if the report is open or code to trap the error that will be generated if the report is not open.

[pacarv]

Thank you very much for your quick response. Unfortunately I'm not using a ListBox; I've set everything up to be accessable from buttons on the switchboard. For instance... clicking on the Category Reports button opens another switchboard that lists each report for individual categories. The report opens in another window, its this window I want to print from the print button on the switchboard. Does that make sense?

Should I be using a ListBox instead of the way I've explained?

[DonRayner]

Then you are going to have to set a form global variable with the report name when the user clicks on the report to run. Instead of declaring the variable in the private sub, you declare it at the top of the form module right after the "OPTION COMPARE DATABASE" this way it's available as long as your form is open.

In the private sub for each button just before you open the report for preview, you can set the variable to the report name.

So as in my example above Line 1 would go to the top of the module, line 2 would go into the sub for each preview button and the remainder would go into the sub for your print button.

[pacarv]

Thank you again for your help, I'll give it a try and see how it goes.