Using Calendar control to filter subform access 2007

Posted on 2009-04-21
Last Modified: 2013-11-28

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.


Additional Info.

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.

Question by:jpostuma
    LVL 3

    Assisted Solution

    Did you try onchange?

    Accepted Solution

    there is no onchange
    just on updated, enter, exit, lost and got focus

    i might try looking for an onchange in vba now though.

    LVL 46

    Expert Comment

    Hi jpostuma,

    Try using the updated event.
    Also make sure you have all macros enabled in your Trusted settings

    Good Luck!


    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now