Link Child Master using calender control as link master 1

[JimFlower]

I am using the calender control unbound as the link to a subform but I have to move the focus from the calender control before it will update the subform

 

[faeryfyrre]

What is it want want to happen? Have the subform update everytime you change the date on the calendar control without having to move focus from calendar control.

You can put code in either the AfterUpdate or OnChange of the Calendar which forces the Subform to requery.

Me.[Subform1].Form.Requery

Ensure that the Subform name i have in red is actually the name of the Subform control on your mainform.

Alec Doughty
Doughty Consulting P/L

"Life's a competition. Play hard, but play fair"

 

[JimFlower]

Just figured out I can get access to these events threw the vb editor as
they are not listed in the propertys window
it works thanks