Var in Field Name

  • Thread starter Thread starter Chris B
  • Start date Start date
C

Chris B

I am trying to pass a varible and use it in a field name
that is to be set. The field names are FLD_NA,
FLD_NB,...FLD_NZ. What I want to do is pass it a single
letter like "C" and use it something like FORMS!Orders!
FLD_N & "C" = 100. HELP!

Chris
 
Chris B said:
I am trying to pass a varible and use it in a field name
that is to be set. The field names are FLD_NA,
FLD_NB,...FLD_NZ. What I want to do is pass it a single
letter like "C" and use it something like FORMS!Orders!
FLD_N & "C" = 100. HELP!

Chris
Click to expand...

Dim strFieldSuffix As String

strFieldSuffix = "C"

Forms!Orders.Controls("FLD_N" & strFieldSuffix) = 100
 
Back
Top