Help!!!!!! Filtered form and report

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

Steve Schapel

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top