using selection from calendar control as the criteria for a query

[why_me143]

Hey
i was wondering if it was possible so that when the user selects a day on
the calendar a query will run and the date select will automatically be used
as the criteria for the parameter query
e.g hotel booking system
when the user selects a date it will show all the guests arriving that day
Thanks

 

[Arvin Meyer [MVP]]

You can do that if you build a small form for the criteria input. In the
form's unbound textbox, call the calendar, then use the form as the criteria
input:

Forms!YourFormName![Your textbox name]

There's a small sample with my demo calendar form that should show you how:

http://www.datastrat.com/Download/Calendar2K.zip