How do I have a report ask for parameters just one time?

[pld60]

I have 2 queries each with parameters to select month and year [Enter Month #] and [Enter Year]. Both do exactly as I want. When I run a reports based on the 2 queries they work great. How do I run both queries in one report and have it ask for the parameters just once? One report is run as a subreport.

[ajalwaysus]

I would suggest you put a form in front of the report with the date fields as text boxes, that way you can tie the queries to the text boxes and they will inherit the dates on load.
i.e.

SELECT * FROM TABLE1 WHERE StartDate = Forms!MyForm!txtStartDate.Value

I don't think there is another way because your quires are independent, and therefore need independent data entry.

[pld60]

Ok, I created a form that asks for month # and year with a comand button that opens the report and enters the entered month and year for the queries. Everything works great except the report automatically prints and never opens. It prints the correct information. How do I fix it so it just opens the report to review and then can be printed by clicking on print?

[pld60]

I should have added the code for the comand button

Private Sub Command14_Click()
Me.Visible = False
DoCmd.OpenReport "Incident Report by Month", acViewNormal, acEdit
DoCmd.Close acForm, "Report by Month"

End Sub

[ChipR]

Try
DoCmd.OpenReport "Incident Report by Month", acViewReport

[pld60]

Thanks for the responses. ChipR I tried this code and it does the same thing.

[pld60]

acViewPreview is what I needed, thanks for the help