>>>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
>
>Ed,
>
>Nothing as long as xCode never has any leading spaces.
If it did, then the EVAL() above would fail, too. Thanks for pointing out this as a possible source of trouble with macro expansion, especially in name resolution - embedded spaces get treated as separators!