You can call a procedure in a module associated with a subform in one of two ways. If the form containing the subform is open in Form view, you can refer to the procedure as a method on the subform. The following example shows how to call the procedure GetProductID in the Orders Subform, which is bound to a subform control on the Orders form:

In the Orders Subform class module enter:

Public Function GetProductID() As Variant
' Return current productID.
GetProductID = ProductID
End Function

Forms!Orders![Orders Subform].Form.GetProductID

You can also create a new instance (instance: An object that is created from the class that contains its definition. For example, multiple instances of a form class share the same code and are loaded with the same controls that were used to design the form class.) of the form that is being used as a subform, even if neither the main form nor the subform is open, and call the procedure. This will work for any form, whether or not it is being used as a subform. The following example shows how to create an instance of the Orders Subform and call the GetProductID procedure:

Dim frm As New [Form_Orders Subform]
frm.GetProductID

Note
When you create a new instance of a form with a name consisting of more than one word, enclose the class name (class name: The name used to refer to a class module. If the class module is a form or report module, the class name is prefaced with the type of module. For example, Form_OrderForm.) of the form in brackets, as shown in the preceding example.

Zidar: Gde ti se nalazi procedure GlobalnoMaterijal ?