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