R
rburna
Ok, I can't seem to find any information on accessing a field name
dynamicly....
Here is the code
dim iCount
dim iTotal
iTotal = 0
do while iCount <= 16
tThisField = "txtOct" & iCount ' This specifies the field I should be
checking
iTotal = iTotal + VAL(Eval(tThisField))
loop
Logicly this should work, but I keep running into an error telling me
that it can't find the field txtOct1 which is a valid field on the
form....
What am I doing wrong?
Richard
dynamicly....
Here is the code
dim iCount
dim iTotal
iTotal = 0
do while iCount <= 16
tThisField = "txtOct" & iCount ' This specifies the field I should be
checking
iTotal = iTotal + VAL(Eval(tThisField))
loop
Logicly this should work, but I keep running into an error telling me
that it can't find the field txtOct1 which is a valid field on the
form....
What am I doing wrong?
Richard