Report Parameters with no RecordSource

[Bain]

Hopefully this makes sense.

I have a report that consists of nothing but sub reports (attached to parameterized queries) that all take the same parameters. I would like to have the user enter in the in the data parameters once at the beginning.

Right now I have no record source set up for the main report because it only takes the sub reports. But when I set the date text boxes to "=[Enter date]" the report doesnt prompt for input. I have in the past set up a dummy record source the has 1 row, so I can prompt the user for input. I would also rather not create a simple form to take the values.

Is there any way around this? Or am I gonna have to set up a dummy record source?

 

[Fizzio]

Create a form with an unbound textbox where you can put enter the date parameter and the report(s) can take the value from this form.

If you want to make it a little slicker, open the form instead of the report, put a button on the form to open the report and close the form when the report closes.

If you need any help with this, post back

 

[Bain]

I would also rather not create a simple form to take the values.

I dont mean to be a jerk. Any how the form idea is not a bad idea, however I dont think the users will get that they need to click on a form button to print a report.

Thanks for the idea, i will take it in to consideration.

 

[Fizzio]

Sorry Bain, missed that bit of the question

But...in my defence, it is the easiest way to achieve what you are looking for and you can make it clear that the button will print the report by formatting the form as you need to

 

[Bain]

No worries man, thanks again for the help.