S
SF
Hi,
How do I check whetther a form has subform?
SF
How do I check whetther a form has subform?
SF
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
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
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
S
SF
Dear Allen Browne,
Thank you very much for your prompt reply.
SF
Thank you very much for your prompt reply.
SF