Hi. I am trying to run through a series of constants based on filed names.
For example, I have x number of Constant field names named Field1, Field2, Field3, .......,Fieldx.
I would like to do something with the value of those field names without having to state the actual field name, but rather cycling through the fields

For Example:

Dim Record as integer

For Record=1 to x' which is the number of fields

OtherVariable=Field & Record 'I would like to use this to call the value of the constants

Next Record
'----------------------------------------------

This does not work. I am sure I need to do something to tell vba that "Field & Record" is actually a constant/variable and on text/.string.

Can anyone help?