If you need to reference every control on a form, using the Controlscollection will be faster than referencing every control directly. Forexample, if you have four command buttons on a form and you want to setthe Enabled property to False for all of them, you have two options.
Option 1:
cmdAdd.Enabled = False cmdEdit.Enabled = False cmdDelete.Enabled = False cmdNext.Enabled = False Option 2 will execute approximately 10 to 15 percent faster thanOption 1:
For iLoop = 0 To 3 Controls(iLoop).Enabled = False Next 
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
