Can control references be stored in variables?

[wrekless]

Does anyone know if a control name(s), can be stored in a variable? Is concatenation available? I can't get it to work.

Example:
Forms![EQSRCL Update]![OptionMANUF]

Dim FieldName As String
Fieldname = "OptionMANUF"

Could this be manipulated like:
Forms![EQSRCL Update]!Fieldname ????

The reason I have to use this feature is because I have to write a code for 74 fields and instead of repeating it, I was hoping to use a loop.

 

[Travis]

Try this instead. By using the Controls collection you can specify a name or index number. (Most people use the name, who can remember all those numbers)

Example:
Forms![EQSRCL Update]![OptionMANUF]

Dim FieldName As String
Fieldname = "OptionMANUF"
Forms![EQSRCL Update].Controls(Fieldname)