Can Subform Call Main Form Sub Procedure

  • Thread starter edisonl via AccessMonster.com
  • Start date
E

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
 
J

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
 
E

edisonl via AccessMonster.com

Hi Jeanette,

Thanks..

Regards, Edison

Jeanette said:
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,
Click to expand...
[quoted text clipped - 5 lines]
Regards, Edison
Click to expand...
Click to expand...
 
Top