trouble printing reports

[lipin]

I am trying to print 2 reports with a button. Both have the same query as the record source. The query has a date input parameter that prompts the user for a date.

I tried a using macro to open query and then print first report and print second report. But it asks for the date 3 times. I for query and then for each report. How can I stop this from happening?


THANKS!
lipin

 

[WayneRyan]

lipin,

Try this.

Make a new form (pop-up, modal).
Put a date field on it. Not bound to a table.
Put a command button.

In the on-click for the command button:
Check to make sure they have entered a date.
DoCmd.OpenReport "YourReport", acPreview

In the query for your reports make the criteria
for the date field:

=Forms![YourPopup]![TheDate]

or use >= or whatever.

You could run the reports back-to-back or
put a command button for each.

hth,
Wayne