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