Dynamically fill form fields
I want to programmatically fill fields on a form with values stored in an array. Is there a way to do this without specifying the names of the fields? The code would look something like this:
Dim i As Integer
i = 1
Do While i <= vArrayLength
Me.Word(i) = ParseWord(Me.text, i)
e(i) = TranslateText(Word(i))
V(i) = CalcTextValue(e(i), 0, 0)
i = i + 1
Loop
Word(i), e(i) and v(i) are fields (Word1, Word2, Word3, etc; e1, e2, e3, Etc.)
Thanks in advance
|