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!