Force AfterUpdate event

Posted on 2012-09-12
Last Modified: 2012-09-19
I use the ActiveX Calendar control on several of my forms.  I just noticed that when a calendar is used to insert a date into a field on the form, the After Update event is not triggered.

Is there a way I can force the event to happen with VB code?

Thanks for your help.

Question by:JudithARyan
    LVL 75

    Accepted Solution

    Try the On Change event instead ...
    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    and use the .TEXT property of the text box

    Private Sub yourTextBoxName_Change()

       ' some code
       ' example
       If Me.yourTextBoxName.TEXT = <somevalue> ' or whatever ...

    End Sub

    Author Closing Comment

    DatabaseMX, the OnChange didn't work either.  However, I found by using the AfterUpdate on Time entery(Immediatelyfollow date entry) I can use its event to do my testing.

    I accepted you comments as the solution, since you did give me something to try.  Thanks.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    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…
    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

    737 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

    17 Experts available now in Live!

    Get 1:1 Help Now