[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Force AfterUpdate event

Posted on 2012-09-12
3
Medium Priority
?
422 Views
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.

Judith
0
Comment
Question by:JudithARyan
  • 2
3 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 660 total points
ID: 38392803
Try the On Change event instead ...
0
 
LVL 75
ID: 38392809
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
0
 

Author Closing Comment

by:JudithARyan
ID: 38414483
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.

JR
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

825 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