Link to home
Start Free TrialLog in
Avatar of JudithARyan
JudithARyanFlag for United States of America

asked on

Force AfterUpdate event

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
ASKER CERTIFIED SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
Avatar of JudithARyan

ASKER

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