Printing reports

  • Thread starter Thread starter Omar
  • Start date Start date
O

Omar

Again, thanks very much for your suggestions and comments,
you all have been extremely instrumental in my ability to
understand access.

I have a parameter querie setup using the "Between [start
date] and [end date] syntax. I have a print menu that I
use to print the report from this querie. When I try to
print, the "start" and "end" date boxes pop up. What I
would like to do is be able to type in these dates in my
form and have access use these dates to run the querie
instead of prompting the user for this information. Thanks

OMAR
 
Assuming your form name is frmDates and your controls are txtStartDate and
txtEndDate, set the criteria in your query to:
Between Forms!frmDates!txtStartDate and Forms!frmDates!txtEndDate
You can use references to these controls in your report text boxes.
 
Back
Top