Calling subroutine in subform from parent

[guy.murray]

Hi,
I have a subForm in which I have defined a subroutine. I want to call this subroutine from an event in the parent form.

Would be much obliged if someone could explain how to do this.

Guy

 

[allan57]

I use the following to call a procedure from another form:

form_PutYourFormNameThatHoldsTheProcedureHere.TheNameOfYourProcedure

Example:

the procedure I wish to call is named CheckForCommonMaterial held in form fsubSolutions_BOM which is the source of my sub form.

i.e.

form_fsubSolutions_BOM.CheckForCommonMaterial

 

[guy.murray]

Brilliant! Just what I needed.

many thanks

Guy

 

[RuralGuy]

Here's a good link to put in your favorites. Refer to Form and Subform properties and controls

 

[Kenln]

I usualy test to see if the main form is open before I call the procedure. This, of course, is only needed if the sub_form can be opened independently.

 

[The_Doc_Man]

There is also the consideration that if the subroutine is one that might be called from more than one form, or if it can be called from varying depths of form, perhaps it should not be in a form's class module. Instead it should be in a general module published PUBLIC.

Just a thought, perhaps as a matter of style rather than anything technical. I just would find it easier to make that reference.