Help!!!!!! Filtered form and report

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I have to extract from a table the operations made between 2 days. I made a
query where i put as a criteria for the field DATE : Between [Date1] and
[Date2], and appear 2 boxes for introducing Date1 and Date2.
Now, I have to display the rezults in a form and in a report. I made the
form, and when executing it appear the 2 boxes, I enter the dates and I get
the results displayed in the form. In that form I used a command button to
open the report, but appear again the 2 interogative boxes. HOW CAN I GET
THE RESULTS IN THE REPORT USING THAT BUTTON FROM THE FORM WITHOUT
INTRODUCING AGAIN Date1 and Date2 ???
IS THERE A POSIBILITY TO INTRODUCE Date1 and Date2. IN 2 TEXTBOXES IN A FORM
(ONLY ONCE FOR THE FORM AND FOR THE REPORT) AND TAKE THEM FROM THERE FOR
DISPLAING THE RESULTS IN A FORM AS WELL IN A REPORT?

HELP ME PLEASE!
THANK YOU!
 
Chris,

Yes, putting two unbound textboxes on a form as you suggested, for the
entry of the date range criteria, is by far the bast way to do this.
Then you can refer to the textboxes in the criteria of the query liuke
this...
Between [Forms]![YourForm]![DateFrom] And [Forms]![YourForm]![DateTo]
 
Back
Top