Printing Reports

[JRA]

Hello,

I have created my table, form and report, and now I want ot print my report. What is happening though is that each line in my table contains data for a specific month and when I print my report, it's printing the data for every month. What I want to do though is only print the month as requested by the user.

How do I set up a pop-up box so that when the user clicks the print button it will then ask the user to select a month as determined by a combo box linked to the table listing months that have already been input?

I am also a junior programmer, so I really, really need help.

Thanks in advance,
James.

 

[pdldavis]

An easier way to do that would be to have the user select a month from a combo box.

In the combo box Event After Update properties: docmd.openreport "yourreport",acviewpreview.

In the report query criteria for month, criteria = the value of the combo box. Something like:
=forms!frmMenu.CboMonth.

That should do it.