Looping through form controls

tmccollum · #1 (**permalink**) 04-11-07, 00:19

I want to create a common function that will loop through the controls on a form. It needs to be able to work on all forms regardless of how many controls there are. I will then get the values and put them in an array.

cheers

gvee · #2 (**permalink**) 04-11-07, 03:41

Someone on this forum gave me this code in VBA which does what you want. Customize as needed!

Code:

Dim ctl As Control

        For Each ctl In Me.Controls
                Debug.Print ctl.Name
        Next ctl

Internet Services

Web Development

Digital Marketing

Consumer Tech