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
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for