[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Using Calendar control to filter subform access 2007

Posted on 2009-04-21
Medium Priority
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

Assisted Solution

SimonThompson earned 1000 total points
ID: 24198206
Did you try onchange?

Accepted Solution

jpostuma earned 0 total points
ID: 24198274
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

ID: 24202056
Hi jpostuma,

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

Good Luck!


Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Suggested Courses

867 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