asked on

Access VBA - TextBox AfterUpdate event not firing

Hi
I am using the OnChange event to filter data in a subform when the user types in
the text box. I am trying to use the afterupdate even to do the same thing when the textbox is changed programmatically but the AfterUpdate even is not firing

Private Sub LicenceNo_AfterUpdate()
'This does not fire when I use code to change it
    Me.List1.Requery
    Me.SubForm1.Requery
End Sub

Private Sub LicenceNo_Change()
    'This fires when user types
    Me.List1.Requery
    Me.SubForm1.Requery
End Sub

Open in new window

SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Dale Fye

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Murray Brown

ASKER

Hi. I should have explained further that the TextBox value populated from another form that pops up. It is used in over 50 other parts of the application so I don't want to call the After_Update event. I really just need code to fire when the TextBox value changes (without adding to the code that changes it)
I have added a new question on this. https://www.experts-exchange.com/questions/29221970/Access-VBA-Trigger-code-in-form-when-text-box-is-populated-from-another-form.html#questionAdd

Dale Fye

See my response to your new question.