Control Calendar 11.0

S

Scott Dufour

I am not sure how to utilize the Control Calendar 11.0 to be able to click on
a day in the calendar and open a report to show the information in it. I
already have my query and report set up, but would like to connect them to
calendar. Is there VBA code to connect them or would this need to be done
through a macro
 
A

Alex Dybenko

Hi,
add a textbox on calendar form, say txtDateSelected, in calendar control
click event write:

me.txtDateSelected=me.CalendarContol.Value
docmd.openreport "myreport"

and then make your query filtered by Forms!CalendarForm!txtDateSelected


--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
 
S

Scott Dufour

Hello Alex,
Sorry that I was not a little more clearer in what I was asking for. I
already have a form built with the calendar, which it is connected to a
labeled text box with pre-existing dates. I did try what you suggested, but I
believe this is a seperate form. What do I need to do to have a report to
open within the form I built?
Thankyou
Scott D
 
Top