Cycle through variables incremented by a digit

I have an Access form where a bunch of sections are repeated, ex: Name, Age, Gender. The variable names for these text boxes are: Name1, Name2, ...; Age1, Age2, ...; etc.

I want to store all these values in an Array after a button is pressed. Instead of hardcoding all the variable names, I was wondering if there is a way to cycle through these in a for loop e.g.:

For i = 1 to 4
 ArrayName(i) = ("Name" & i).value 
 ArrayAge(i) = ("Age" & i).value
 ArrayGender(i) = ("Gender" & i).value
next i

I can get the string Name1 by ("Name" & i) but when I add .value after it, it doesn't seem to work.

I have also tried storing the variable name as a string into another array and then trying to use that array element to get the value, but that doesn't work either.

from Recent Questions - Stack Overflow https://ift.tt/33fcChh
https://ift.tt/eA8V8J