Table of contents
Collapse the table of content
Expand the table of content

Call Procedures in a Subform or Subreport

office 365 dev account|Last Updated: 6/12/2017
1 Contributor

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
© 2018 Microsoft