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.
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.