Firing Change event from popup form

[Mark A. Sam]

Hello,

This code is on the AfterUpdate event of a list box on a popup form.

Private Sub Company_AfterUpdate()

Dim frm As Form
Set frm = Forms![LoadSheetsMain]![LoadSheetsST].Form
frm.Controls(OpenArgs) = Me.ActiveControl

End Sub


It assignes a value to a textbox on the calling form. I need to fire the
change event of that textbox, but don't know the method.

Thanks for any help.

God Bless,

Mark A. Sam

 

[kingston via AccessMonster.com]

The change event of the textbox must be Public. You can then call it from a
different control or form:

Forms!FormName.PublicSub

Hello,

This code is on the AfterUpdate event of a list box on a popup form.

Private Sub Company_AfterUpdate()

Dim frm As Form
Set frm = Forms![LoadSheetsMain]![LoadSheetsST].Form
frm.Controls(OpenArgs) = Me.ActiveControl

End Sub

It assignes a value to a textbox on the calling form. I need to fire the
change event of that textbox, but don't know the method.

Thanks for any help.

God Bless,

Mark A. Sam

 

[Mark A. Sam]

Thanks. The Event is public, but I need to know to go the next step from my
code below to firing the event. This is generic and I will use it again in
other textboxes so I can't specify the control name.

The change event of the textbox must be Public. You can then call it from
a
different control or form:

Forms!FormName.PublicSub

Hello,

This code is on the AfterUpdate event of a list box on a popup form.

Private Sub Company_AfterUpdate()

Dim frm As Form
Set frm = Forms![LoadSheetsMain]![LoadSheetsST].Form
frm.Controls(OpenArgs) = Me.ActiveControl

End Sub

It assignes a value to a textbox on the calling form. I need to fire the
change event of that textbox, but don't know the method.

Thanks for any help.

God Bless,

Mark A. Sam