Firing Change event from popup form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark A. Sam - 22 Mar 2007 20:45 GMT

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

Reply to this Message

kingston - 22 Mar 2007 21:38 GMT

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

Forms!FormName.PublicSub

>Hello,
>
[quoted text clipped - 16 lines]
>
>Mark A. Sam

Reply to this Message

Mark A. Sam - 23 Mar 2007 03:11 GMT

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
[quoted text clipped - 22 lines]
>>
>>Mark A. Sam

Reply to this Message