Print Reports

[Bill]

Thanks Steve,

I put four queries like you provide "Between...... and .... " . When
I get preview report with four different subforms then I decide to click
a print button (toolbox). The result is that i get four times two pop-up
box to enter from and to date. Can I do once from the form when
entering from date and to date so that it takes care of it all including
print button.

Your feedback will be much appreciated.

Thanks,

********************************
Bill,

One approach you might consider is to put two unbound textboxes on your
form, and enter your beginning date and end date in these textboxes.
Then, in the query that your report is based on, you can refer to these
textboxes in the criteria. If I understand you correctly, this will
mean something like this in the criteria of your date field in the query...
Between [Forms]![YourForm]![DateFrom] And [Forms]![YourForm]![DateTo]

 

[Steve Schapel]

Bill,

That's exactly what I meant! However, the form has to still be open,
with the dates enterend in the unbound textboxes on the form, at the
time that the report is printed.

 

[Michael Cheng [MSFT]]

Hi Bill,

I wanted to post a quick note to see if you would like additional
assistance or information regarding the information MVP Steve has provided.

Thank you for your patience and cooperation and look forward to hearing
from you!

Sincerely yours,

Michael Cheng
Microsoft Online Support
***********************************************************
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.