Calander on Click on Form

[scott04]

Hi everyone,
I apologize ahead of time if my thoughts are all over the place. I have a
form that acts like a switchboard which is used to pull the different reports
that i have created. On the form i have unbound combo boxes: Startdate and
EndDate. On the mouse down function I have code that makes visible my
calender and places my date into my combo box. Also on the form I have a
button that will open one of my reports.
My question is how can I use the dates that i entered for StartDate and
EndDate and have my report only grab data within that range. I usually use a
parameter query but the Calander control 11.0 looks so much better to a
viewing audience and i dont have experience doing it. Any help is
appreciated. Thanks.

 

[Allen Browne]

Regarding the report, see:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

The Calendar control looks nice, but may give you support nightmares. It
tends to break with different versions of Access, so my preference is just
to use a little popup form that looks like a calendar but is actually part
of Access so it avoids the versioning problems. Use this one if it helps:
http://allenbrowne.com/ser-51.html

 

[scott04]

Thanks Allen this is exactly the direction i needed.