Objects and Variables
I have problem that bugs the hell out of me.
Is there some way of accessing an object by a variable name? ie
instead of
frmMain.cbParts1.value up to frmMain.cbParts10.value
use a variable to give
frmMain.("cbParts" & iCount).value
to loop through them. I have tried using the Controls but it
sometimes results in the controls out of sequence so that I address
cbParts7
cbParts1
cbParts2
cbParts3
cbParts4
cbParts5
cbParts6
cbParts10
cbParts8
cbParts9
which when filling in a form isnt that great.
Is there any way to use a variable in an objects name?
Thanks in advance
Geoff
|