D
Dan
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/columns: 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 (named [FMonth] or [EMonth]) 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. Rendering this value through a simple statement of
[FMonth] is sufficient. Deriving the value of does not require use of ! and
.. operators to specifically call on the data from elsewhere in the form.
I've posted this problem on a couple of other forums and received a reply to
make the following statement:
MyCombo.Column(1)
Given this, I have adapted it to [fmonth].column(2) to display the French
month, for instance (note table structure in second paragraph above).
However, upon entering this in Expression Builder, the system corrects the
syntax to [fmonth].[column](2) which results in #Error when displayed.
What is the syntax required in expression builder to have a lookup table
display information from a specified column when the field already
displaying the information renders a PI of the numeric value from column 0?
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/columns: 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 (named [FMonth] or [EMonth]) 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. Rendering this value through a simple statement of
[FMonth] is sufficient. Deriving the value of does not require use of ! and
.. operators to specifically call on the data from elsewhere in the form.
I've posted this problem on a couple of other forums and received a reply to
make the following statement:
MyCombo.Column(1)
Given this, I have adapted it to [fmonth].column(2) to display the French
month, for instance (note table structure in second paragraph above).
However, upon entering this in Expression Builder, the system corrects the
syntax to [fmonth].[column](2) which results in #Error when displayed.
What is the syntax required in expression builder to have a lookup table
display information from a specified column when the field already
displaying the information renders a PI of the numeric value from column 0?