Question Printing a selection from a combo list

[Tumby]

THANK YOU! THANK YOU!
I know I did say print- sorry,
But I do think it's best to see what is going to be printed before you actually print.

Thanks again!

 

[dkinley]

Agreed. I always run the preview - never print blind.

You are very welcome - awesome that it is going and you picked up some nuggets along the way!

Good luck with your project.

-dK

 

[Simon_MT]

I have a Table for Sales Reports and use a form with fields Sales Report (ID) and a Textbox called Sales Report Desc which represents:

=[Sales Report].[Column](1)

Now that I have the Name of the Report I have two buttons Detail / Summary with separate functions to handle each:

        Dim SalesReport As String
        SalesReport = .[Sales Report Desc]
        DoCmd.OpenReport SalesReport, acViewPreview, , SalesReports_Criteria

Dim SalesReport As String
SalesReport = .[Sales Report Desc] & " Summary"
DoCmd.OpenReport SalesReport, acViewPreview

User can call different reports as code sets Sales Reports to the equilavent ID to their request.

Simon