How to: Call Procedures in a Subform or Subreport

You can call a procedure in a module associated with a subform or subreport 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 this code:

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

The following code illustrates how to call the GetProductID procedure.

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