Can Subform Call Main Form Sub Procedure

[edisonl via AccessMonster.com]

Hi,

1. I have a Main form where consists of mutliple subform.

2. In code editor of subform A, am i able to call local sub procedure that
resides in
main_form ?

Regards, Edison

 

[Jeanette Cunningham]

Hi edisonl,
Yes this is possible.
Make the sub procedure on the Main form a public sub -- Public Sub
SubName()

In subformA your code goes like this-->
Me.Parent.SubName

or you can use

Call Me.Parent.SubName

Note: replace SubName with the actual name of the sub procedure.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[edisonl via AccessMonster.com]

Hi Jeanette,

Thanks..

Regards, Edison

Hi edisonl,
Yes this is possible.
Make the sub procedure on the Main form a public sub -- Public Sub
SubName()

In subformA your code goes like this-->
Me.Parent.SubName

or you can use

Call Me.Parent.SubName

Note: replace SubName with the actual name of the sub procedure.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

Hi,

[quoted text clipped - 5 lines]

Regards, Edison