Collections ?

[cheuschober]

Is there a 'catch all' way to select only the controls found within a specific section of the form... say I wanted to perform an operation on all the controls in the detail section of the form but not those found in the header or footer?

Any quick way (collection) to this solution?

Many thanks,
~Chad

 

[ChrisO]

G’day Chad.

Something like this should get the job done: -

Option Explicit
Option Compare Text


Private Sub Form_Open(Cancel As Integer)
    Dim ctl As Control
    
    For Each ctl In Me.Section(acDetail).Controls
        MsgBox ctl.Name
    Next ctl

End Sub

Hope that helps.

Regards,
Chris.