hi guys
thanks for the previous help.
now i'm trying to lopp through certain textfields and depending on the value in those textfields: do something
the fields are named Freq1, Freq2, Freq3, etc
I've created an index starting at 1 and am trying to join "Freq" & index togetther to then get the value out of each textfield. here is my code which works if I make separate entries for each textfield, but in some cases i'm going to have 50 textfields to create so i'd rather use a loop.

Do While (index <= MeasNo)

Dim newFreq, newIn
newFreq = "Freq" & index
newIn = "In" & index


If newFreq = "monthly" Then

If (Day(DateBox.Value) <> Day(EndOfMonth)) Then
If (Day(DateBox.Value) = Day(EndOfMonth) - 1) Or (Day(DateBox.Value) = Day(EndOfMonth) - 2) Then
newIn.Enabled = True
Else
newIn.Enabled = False
End If

Else

newIn.Enabled = True
End If

ElseIf newFreq = "weekly" Then
If Weekday(DateBox.Value) <> 6 Then
newIn.Enabled = False
Else

End If

ElseIf newFreq = "daily" Then
newIn.Enabled = True

End If


index = index + 1
Loop


thanks in advance
ActionAnt