CallByName (Resolved)

[scostell]

am I doing something wrong here?

CallByName frmProspects, frmProspects.chkRequired(i).Tag & ".backcolor", VbLet, &HC0FFFF

what i'm trying to do is...I store the name of a textbox in the tag of a checkbox. I search through the checkboxes and if it's checked I want to turn the backcolor of the textbox(who's name is in the tag property of the checkbox) yellow.

Can you do this with callbyname funtion and if not is there another way(or trick) to do it?

I know I can search thru the all the controls until the name matches the one in the tag property but there are to many controls to do that and seems slopy. IMO

[scostell]

for those who may be struggling to figure this out also what I did was I set an object equal to the callbyname statement.

set obj = callbyName(frmprospects, chkprospects.tag,vbget)


and now the obj represents the object that was stored as a string value in the tag of the checkbox. so now i just

obj.backcolor = vbyellow



works perfectly.

Thanks to anyone who read my question and hopefully I can help someone figure out the same problem.