onClick in Calendar Control 11??

[capdownlondon]

I need to update a subform each time a differen date is clicked, but there is no onClick in the prefrences of Calendar Contol, so i can't work out how to do this.
Could someone please help. Its driving me mad.

thanks

adam

 

[CEH]

AfterUpdate

 

[capdownlondon]

yeh i tried that and it does seem to work. i put forms!RedsForm.RedsFormSub.requery into AfterUpdate and it doesnt seem to change the subform.

by the way - if i set the date on the calendar to a different date, then close and then open the form again the records in the subform DO change to that date. but i have to open and close the form 1st.

 

[capdownlondon]

oh wait just noticed, i did what you said in OnUpdate, is that the same as AfterUpdate? i can't find AfterUpdate anyhow.

 

[CEH]

Sounds like it is not saving the record before it is doing the requery.

 

[capdownlondon]

ah, ok this poses a new approach to the question then. i want to do 2 things with the calendar. 1- i want it when selected to update the current record (containing a date field amongst other fields) to that date (this has been no problem, when i "add the record").
2- i want it to display all records from that date in a subform.

in theory i thought this may be possible

ideas? need more info?

thanks