Print a reports using a combo box choice on a form

[access2010]

We would like to choose a report from the form in our Access 2003 database
The chosen report, which is in column 2 would have its name shown in the combo box
The print button would be clicked and the report would be previewed prior to printing or canceled.
Your assistance will be appreciated.

Thank you,
Nicole

 

[bob fitz]

Perhaps like attached

 

[JMZ]

Try this...

 DoCmd.OpenReport "ReportName", acViewPreview

 

[Pat Hartman]

I don't know what Bob did (although I'm sure it is correct). I don't ever examine "try this" solutions.

The code would be:
DoCmd.OpenReport Me.cboReport.Column(1), acViewPreview

That assumes that the first column of the RowSource is the user friendly name of the report and the second, hidden column is the name of the report object which should be more like rptAnnualRecap. Object names should never include special characters or embedded spaces. This method allows you to make a table with two columns;
UserFriendlyName (ex. Annual Recap)
ObjectName (ex. rptAnnualRecap)

The .column property of the combo is a zero-based array. We reference the first column (or the bound column) by just using Me.ControlName, but the bound column (assuming it is the first column) could also be reverenced as Me.ControlName.Column(0) or even Me.ControlName.Value. I know, way TMI

 

[bob fitz]

I don't know what Bob did (although I'm sure it is correct). I don't ever examine "try this" solutions

May I ask why that is Pat? Just curious

 

[onur_can]

I also agree with Pat Hartman. I never like to try this solution suggestions. You must give precise instructions. The solution to this problem looks like this.

 

[Pat Hartman]

Hi Bob,
I don't look at them because I have no idea what might have been changed so it requires examining too many things. Just saying "try this" also makes it harder for the OP to understand the solution and either implement it in his real database or use it in a different context some time in the future. When i actually modify a database for someone, I give them a summary of what I changed to solve the problem. Such as - your column was defined as an integer and so that is why it wasn't showing any fractional amounts. You were referencing the items in the option group but you need to reference the option group control to get the value. I changed the import to link instead so you don't bloat the database by constantly adding/deleting rows, etc.

Also, if I can explain in a sentence or two and give sample code where needed, I don't make the change myself. If is a better learning experience for the OP to try to implement the instructions. The method is more likely to be remembered.

 

[bob fitz]

Hi Bob,
I don't look at them because I have no idea what might have been changed so it requires examining too many things. Just saying "try this" also makes it harder for the OP to understand the solution and either implement it in his real database or use it in a different context some time in the future. When i actually modify a database for someone, I give them a summary of what I changed to solve the problem. Such as - your column was defined as an integer and so that is why it wasn't showing any fractional amounts. You were referencing the items in the option group but you need to reference the option group control to get the value. I changed the import to link instead so you don't bloat the database by constantly adding/deleting rows, etc.

Also, if I can explain in a sentence or two and give sample code where needed, I don't make the change myself. If is a better learning experience for the OP to try to implement the instructions. The method is more likely to be remembered.

Thank you Pat. I think you make some good points. I shall try to keep them in mind for the future.