Need to fill in a textbox from data all based upon the same variable

[John Brainard]

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:

varIndex = 1
Do while varIndex < 9
   If [Service(varIndex)-Name] IsNot Null Then
      txtDetailName(varIndex) = [Service(varIndex)-Name]
      txtDetailData(varIndex) = [Service(varIndex)-Total]
   End If
   varIndex = varIndex + 1
Loop
 
 

see, i need to reference 2 textboxes and 2 table datafields all with that variable, then increment and check the next one.

The end result is some records don't have a Service1, but have a servic3, and just putting them all on the form would leave blank boxes everywhere, where this cleans it up.

Thanks in advance, i am struggling here!!