You could do something like this to determine the buttons in the Header Section of a form (for example)


    Dim ctrl As Control
    
    For Each ctrl In Me.Section(acHeader).Controls
        If ctrl.ControlType = acCommandButton Then
            MsgBox ctrl.Name
        End If
    Next
    

Thanks Kevin, but I am looping through all buttons on a form and need to know which section they are in.
To go your way I would need to loop through each section separately. I guess I could do that but I was hoping there was a better way.

Haven't checked but you might be able to loop through all the controls (Me.Controls) and there might be a section property you can check on.

Yea just as Alex said, using basically same code Kevin gave you you can just do
Private Sub Command1_Click()
    Dim ctrl As Control
    
    For Each ctrl In Me
        MsgBox ctrl.Name & " " & ctrl.Section
    Next
End Sub

These are the values it returns
0 acDetail Form detail section
1 acHeader Form header section
2 acFooter Form footer section
3 acPageHeader Form page header section
4 acPageFooter Form page footer section

Nice solution. :)

Thanks Adam
I'll give that a go tomorrow. Unfortunately it's bedtime right now :O(

Hi Guys
Thanks to you guys my code is working perfectly.
I have a colour system where the user can choose their own colours for form background and button colours.
It works by checking for keywords in the form caption and in the button captions.
The problem was that if I had, say, an entry for Email the email form background and a button containing the word email then were the same colour making the button hard to see.
By checking which form section contained the button I could ensure that the button did not get the same colour as the section background.
I am partially sighted so this colour feature makes my life much easier.
So, thanks again guys for taking the trouble to help.