Converting Numerical Value to Lookup value

I am using an expression in Forms to take several fields of data and
convert them to a block of text.

For one of the fields set-up as a combo box, it is based on a Lookup of
a separate table to text in a specified field. The table of data that
is looked up has 3 fields: Index [numeric, 1-12], Eng [Month of the
year in English], Fr [Month of the year in French].

When I concatenate the fields into the expression, the field for looking
up the month displays as the numeric value of the lookup table, not the
corresponding French or English value as it does in the rest of the
form.

What is the syntax required in expression builder to have a lookup table
display information from a specified column?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

"Dan" <anonymous@liamtoh.com> wrote in message
[color=blue]
> For one of the fields set-up as a combo box, it is based on a Lookup of
> a separate table to text in a specified field. The table of data that
> is looked up has 3 fields: Index [numeric, 1-12], Eng [Month of the
> year in English], Fr [Month of the year in French].
>
> When I concatenate the fields into the expression, the field for looking
> up the month displays as the numeric value of the lookup table, not the
> corresponding French or English value as it does in the rest of the
> form.
>
> What is the syntax required in expression builder to have a lookup table
> display information from a specified column?[/color]

I'm not sure if I have the right angle here but if you have a combo which
gets its data from 3 columns then you can refer to any of those values by
syntax something like
MyCombo.Column(1)

The Column property is zero based so Column(0) would be the index, Column(1)
would be English etc.

Cheers,
Peter