variable inside a variable

[bradley7]

hi guys

can someone help me with thiis

endPart = "cboItems" & loopn & ".text" (where loopn is 1 to 5)
Jobs(1).JobMoreInfo(1).JobShortDesc = Value(endPart)

cboItems1 to 5 are combo boxs

I trying to do the above in a loop

should be
Jobs(1).JobMoreInfo(1).JobShortDesc = cboItems1.text
but i get the value in Jobs(1).JobMoreInfo(1).JobShortDesc as "cboItems01.text"
not the actual value of cboItems1.text.

i thought it may be
Jobs(1).JobMoreInfo(1).JobShortDesc = value(endPart) but is getting an error


Brad

 

[p45cal]

untested:
endPart = "cboItems" & loopn '(where loopn is 1 to 5)
Jobs(1).JobMoreInfo(1).JobShortDesc = Me.Controls(endPart).Text

or forget setting endpart:
Jobs(1).JobMoreInfo(1).JobShortDesc = Me.Controls("cboItems" & loopn).Text

(Me. might screw things up depending on where the code is)

 

[bradley7]

Thank you
Never use me.control before