text box referencing

[lil_babie_z]

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 =)

 

[Norie]

Where are these textboxes?

Is this Access or Excel?

 

[ezakovich_35]

using arrays

you could use an array to reference your text boxes and then loop through it to run your check.