List Box Value

  • Thread starter Thread starter Martin
  • Start date Start date
M

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
 
Try:
=[Forms]![Main Menu]![Field1].Column(1)

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

Thank you, it worked perfectly.

Martin

Allen Browne said:
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.

Martin said:
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
Click to expand...
Click to expand...
 
Back
Top