List Box Value

[Martin]

Hello,

I have a report that is run from a form and has various list boxes allowing
the user to filter the data in the report. At the bottom of the report I
want to display the value of the filters, so they know what they have
filtered on for reference.

The list boxes have two columns, one visible and the bound column is not
visible. When I add on the field to the report (=[Forms]![Main
Menu]![Field1]) this displays the bound field value.

What i need is to show the other field, the non bound field. Is that
possible?

The non bound field has more descriptive text that the boudn field, that is
why it is there.

Thanks in advance,

Martin

 

[Allen Browne]

Try:
=[Forms]![Main Menu]![Field1].Column(1)

The first column is zero, so Column(1) is the 2nd column.

 

[Martin]

Allen,

Thank you, it worked perfectly.

Martin

Try:
=[Forms]![Main Menu]![Field1].Column(1)

The first column is zero, so Column(1) is the 2nd column.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have a report that is run from a form and has various list boxes
allowing
the user to filter the data in the report. At the bottom of the report I
want to display the value of the filters, so they know what they have
filtered on for reference.

The list boxes have two columns, one visible and the bound column is not
visible. When I add on the field to the report (=[Forms]![Main
Menu]![Field1]) this displays the bound field value.

What i need is to show the other field, the non bound field. Is that
possible?

The non bound field has more descriptive text that the boudn field, that
is
why it is there.

Thanks in advance,

Martin