Using Calendar control to filter subform access 2007
Posted on 2009-04-21
I have a form which contains the calendar control 12.0 (activex)
I am trying to filter a subform with it.
The problem I am having is the 'on update' click event won't fire.
I became suspicious after trying a hundred different versions of requery
so I wrote a msgbox in the 'on update' event for the calendar control.
Why can't I get this to fire.
Alternatively, where can I place my requery code so that when
a user selects a date in the calendar control, the event will fire.
Parent form: frmmain - normal view
Sub form : sbfrm (contains calendar (calendar1) ) - normal view
sub sub form: ssbfrm (contains records to be displayed) - continuous view.
subform and sub subform are unlinked
sub sub form's recordsource is a query which is filtered by the 'where' relating to the calendar.