"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
