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.

 

[sebkerr]

There are a copule of ways to do this. You could either have the report running from a parameterized query, so when the user opens the report it then pops up a dialog box, such as "|Enter Month?"

Another way is to setup a form with a combo box, where the rows are the months to select. Then use this control as above as the parameter. Then when the report is opened it will limit the report to the records based on the selection

Hope this helps

Sebkerr