Run a control's Event Procedure from another form

[ShinyPen]

Hi,

In Access '97 I have a main form with a pop up form. Is it possible to call the main form's Event Procedures from the pop up form?

e.g I want to call the main form's "AfterUpdate" procedure for a list box while the pop up form is open and has the focus.

Thanks for any help.

 

[RichardHayes]

You should be able to use the command :
Forms("FormName").ControlName.ProcedureName (Parameters)

Make sure the procedure isn't private to the form (change Private Sub to Public Sub).

 

[ShinyPen]

Thanks for the reply Richard.

My form is called frmPERSON & my listbox is called lstCourseSummary. I've made the lstCourseSummary_AfterUpdate public not private.

I've tried the following syntax and neither work. It comes up with an "Object doesn't support this property or method" error.

Forms!frmPERSON.lstCourseSummary.lstCourseSummary_AfterUpdate

Forms("frmPERSON").lstCourseSummary.lstCourseSummary_AfterUpdate

 

[PHV]

And this ?
Forms!frmPERSON.lstCourseSummary_AfterUpdate

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ShinyPen]

Yes! That's the one.

"Forms!frmPERSON.lstCourseSummary_AfterUpdate" does the trick.

Many thanks both of you for your help.