Hi guys
I'm having a form with multiple unbound textboxes (1..30) on it.
Now i'd like to change the backgroundcolor on all of them depending on a lookuptable. I know it can be done manually but i'd like to tweak the code so I hope you guys can help me.
My own try of getting the code tweaked textboxes looks as follows.
if me.[(i) & textbox2008] > Dlookup("Value", "tblCheck")then
For i = 1 to 30
me.[(i) & textbox2008].backcolor = 255
next i
end if
I'm having a form with multiple unbound textboxes (1..30) on it.
Now i'd like to change the backgroundcolor on all of them depending on a lookuptable. I know it can be done manually but i'd like to tweak the code so I hope you guys can help me.
My own try of getting the code tweaked textboxes looks as follows.
if me.[(i) & textbox2008] > Dlookup("Value", "tblCheck")then
For i = 1 to 30
me.[(i) & textbox2008].backcolor = 255
next i
end if