Background: i have a table with data in it, field names [Service1-Name] & [Service1-Total] from Service1 through Service8.

i have textboxes on my form named:
txtDetailName1, txtDetailData 1

Here is an example of WRONG code that won't work, but better explains what i am trying to do:

Code:
varIndex = 1
Do while varIndex < 9
   If [Service(varIndex)-Name] IsNot Null Then
...