Select report to print, Help!

G

GerryE

I have syncronized two combo boxes. The first one "ReportCountry" displays
the the country for the reports to be shown on the next combo box. The
second combo box "ReportName" displays the reports available for that country.
I have also added a print preview button to my form, but I cannot get it to
display the report that was selected from the second combo box. The code
behind the button is:

Private Sub PrintPreview_Click()
RunCommand acCmdSaveRecord
DoCmd.OpenReport Me.ReportName, acViewPreview

End Sub

What can I do to make the button work?
Please help!
 
C

Carl Rapson

Two questions:

1. What is the bound column of the second combo box? Does the bound column
contain the name of the report, or something else?

2. What does happen when you click the preview button?

Carl Rapson
 
Top