Thanks for the tips...I think I've got it.
I belieive I can use the following syntax to get the results I need using the (Controls) array:
Dim i as Integer
For i = 1 to 50
Forms!MyForms.Controls("Control" & i) = "MyValue"
Next i
I was wondering how to reference and update control on a form from a module without explicitly knowning the control name. For example, if I have a bunch of controls:
Forms!myForm!Control1
Forms!myForm!Control2
...
How could I loop through them to set their values using a for/next loop? This...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.