Form + Query + Report

[Jchristensen]

So far this forum and everyone here has been a good help!

Now, I want to have a form with one button. (others of course but this one button is special) that when someone clicks it, it prints multiple reports at once.

BUT each report has a query obviously that searches out what records to pull between two dates. Now, ive somewhat tried this before but what ends up happening is when they click on it.. (there is 4 reports printing) it asks the person 4 times the dates its between. Which is a hastle and people would not be happy about.

What i want is when someone clicks this button, it comes up with one prompt. This promt will then print out the 4 reports with the date provided.

On each report im using the "between" statement in the query to pull results.

This is open to you! PLEASE help! Thanks so much,
Jon

 

[ColinEssex]

Make a little form which pops up to enter the start and end date on. Reference this form and fields in the query, then have the form close when the reports are printed.

Col

 

[Michael J Ross]

Get the user to enter the dates in text boxes on a form and put the date criteria in your queries as Between [Forms]![NameofForm]![DateFromtextboxname] And [Forms]![NameofForm]![DateTotextboxname]

This way they will only enter dates once.

 

[Jchristensen]

Thanks so much for your input!

I thought about aproaching it that way but had no idea how

Thanks again,
Jon