Select date - Run Report

[TTF]

I am having a form with a list box where dates should be displayed.
I am Running Report that is suppose to run for Selected in ListBox dates.
What is the best way to do it to insure Report performance? Simple but forever..
Also multiply dates selection should be available.

Report is based on table that has Date field or it can be a query that pulls Distinct date to display in ListBox.


Thanks so much

 

[TTF]

Report will be run from Query that Report based on.
So my dilemma is how to let Query know for which dates to run...

 

[MD5150]

Just create a query and have the date criteria reference your form criteria. Usually searching between two dates is the way to go using two text boxes or combo boxes.
If searching on one date only, just enter same dates in each box.

So your date field criteria would be:

Between [Forms]![MyFormName]![MyControlName] And [Forms]![MyFormName]![MyControlName]

Mike Dorthick

 

[TTF]

Thanks, it is solved now in a different way because my Access wouldn't react on [Forms]![MyFormName]![MyControlName] I suspect installation screw up...Thanks you