How to check if form has subform

[SF]

Hi,

How do I check whetther a form has subform?

SF

 

[Allen Browne]

Loop through the Controls of the form, to see if any have a ControlType of
acSubform:

Dim ctl As Control
For Each ctl In Me.Controls
If ctl.ControlType = acSubform Then
Debug.Print ctl.Name & " is a subform"
End If
Next

 

[SF]

Dear Allen Browne,

Thank you very much for your prompt reply.

SF