>>>Hi Erik,
>>>
>>>>cFieldName = "CodeList.Code" + xCode
>>>>uValue = EVAL(cFieldName)
>>>
>>>And with an eval() you don't need to define the variable, unlike macro expansion:
>>>
>>>uValue = EVAL("CodeList.Code" + xCode)
>>
>>Mike, while I like EVAL() as a much better solution, what's wrong with:
>>
>>uValue = CodeList.Code&xCode
>
>Anyway isn't it clearer to use EVAL than macro expansion. And the doc says that EVAL is faster...


I don't disagree - but the line of code I posted is legal, and accomplishes the task without the need for the intervening memvar. I rarely advocate macro expansions, but Mike's syntactic argument was not correct. I did state up front that, IMO, EVAL() is a better solution.