Printing multiple reports

D

Debbie

I'm no expert in access and need help/advice on the best way to solve my
problem.

I complete a data entry form containing 9 subforms. Not all subforms will be
completed for each record. Currently, each subform contains a print button. I
would like to be able to select subforms for printing from a single source.

I want to create a form showing all reports with the option to select for
printing, then click a command button to print. But I'm not sure how to go
about this. Can anyone help?
 
K

Klatuu

I would suggest a multi select list box. Use a Value List as the Row Source
that contains the names of all the reports you may want to select.
Once the user has select one or more reports, use the ItemsSelected
collection of the list box to to the printing:

Private Sub cmdReports_Click()
Dim varItm As Variant

For Each varItm In Me.lstReportSelector.ItemsSelected
DoCmd.OpenReport Me.lstReportSelector.ItemData(varItm)
Next varItm

End Sub

lstReportSelector is the name I chose for the list box, change it to match
yours. Same goes for cmdReports, the command button to generate the reports.
 
Top