Print screen input for parameter querie

  • 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
 
Add two unbound controls in your form. Start date and End date

In your query that your report uses change the criteria to
between [Forms]![form name]![Start_Date] and [Forms]![form
name]![end date_Date]

Jim
 
Back
Top