Select report to print, Help!

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top