linking the date control to list box

[gambithunt]

Hi all

I inserted the calender and I would like to use it to to control the list box, when I click on a particular date on the calender I would like the list to display only those entries on the table that correspond to that month which the calender is at.

Help would be much appreciated.

G

 

[Dennisk]

use a query that refers to the Year of the date as returned by the calander control, as its filter criteria and use that query for your list.

 

[gambithunt]

use a query that refers to the Year of the date as returned by the calander control, as its filter criteria and use that query for your list.

Thanks

but how do I do that, how do I control the filter the query for the form when the calander is clicked on, and then how do I make that query applicable to that list

 

[boblarson]

Set a hidden text box and set the after update event, or on change event of the calendar to update that hidden text box with the value. Set your query's criteria to be that text box.

 

[gambithunt]

Set a hidden text box and set the after update event, or on change event of the calendar to update that hidden text box with the value. Set your query's criteria to be that text box.

thanks

One more question, what is the code that allows me to set my queries criteria on that hidden text box? How should it be written?

 

[boblarson]

Is it a saved query built in the Query By Example grid? If so, put your mouse in the criteria, click the builder button and navigate to forms and then the control on that form and add it in.

 

[gambithunt]

Is it a saved query built in the Query By Example grid? If so, put your mouse in the criteria, click the builder button and navigate to forms and then the control on that form and add it in.

thanks for the help