>>Hi Barbara,
>>
>>The problem here, that I don't have code+description as a separate table. I created an include file, where I set variables, like APNEDT "E", etc. I was thinking, is it possible to set controlsource like iif(APNEDT,APNEDTDESC,...). Since there are ~5 different values, it would not be convenient to use iif, it's better to use some function here. My question is: could it be done?
>
>You could set a function as the controlsource of a textbox, which would have that one-char field as a parameter, and return the string.
Could it be a form method? E.g. in properties ControlSource put something like:
thisform.GetDescription(APN)?
If it's not broken, fix it until it is.
My Blog