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!
>
>
>

Dear Chris

A simple way is to create a new form not based on any
tables or queries (unbound). On this form put two text
boxes one for Date1 and one for Date2. Also put on the
form two buttons - one for OK and one for CANCEL. The
onclick event of the OK button will open the form that is
based on your query.

Now open your query in design view and in the date field
criteria put BETWEEN FORMS![NEWDATEFORM][!DATE1] AND FORMS!
[NEWDATEFORM]![DATE2]
This way, as long as the NEWDATEFORM form is open your
form and report will only ask for the parameters once.

Hope this helps

Paul Falla
>-----Original Message-----
>
>
>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!
>>
>>
>>
>
>
>.
>