Avatar of Murray Brown
Murray Brown
Flag for United Kingdom of Great Britain and Northern Ireland

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

Microsoft AccessVBA

Avatar of undefined
Last Comment
Dale Fye

8/22/2022 - Mon