lil_babie_z
New Member
- Joined
- Nov 8, 2005
- Messages
- 3
ok-
so i have a bunch of text boxes - about 100 of them. named day00, day02, day03... day10 day12 day13... day20 day21 day22.... so on and soo soo.
it's all lined up and what i want to do is when it losses focus and the value is not 8 - it calls up a function that asks for more information.
(what the whole thing is, is an attendance sheet kinda - if they don't have a full 8 hr attendance it asks for more details why. )
anyway - is there any way i can reference to the text box value without saying "day01.text" or day00.value so i can just copy and paste to the every lost focus event with changing from day00.text to day01 day02... yadi yadi yaya. .... maybe say
if not text ="8" then....
instead of going
if not day01.value ="8"
i know - i said too much.. it's the coffee - i had 3 =)
so i have a bunch of text boxes - about 100 of them. named day00, day02, day03... day10 day12 day13... day20 day21 day22.... so on and soo soo.
it's all lined up and what i want to do is when it losses focus and the value is not 8 - it calls up a function that asks for more information.
(what the whole thing is, is an attendance sheet kinda - if they don't have a full 8 hr attendance it asks for more details why. )
anyway - is there any way i can reference to the text box value without saying "day01.text" or day00.value so i can just copy and paste to the every lost focus event with changing from day00.text to day01 day02... yadi yadi yaya. .... maybe say
if not text ="8" then....
instead of going
if not day01.value ="8"
i know - i said too much.. it's the coffee - i had 3 =)