Want to show second column of list box in report textbox

[Frank72]

Hows it going

I want to put a date at the top of a report, simple enough but the date i want to show id the second column of a double column list box and therefore the index is being shown, ive tried [forms]![frm]![listb.column(2,comb.listindex)]
this seemed like a long shot but there must be a way of getting the second column to show in the report text box. obviously i cant change the bound coluimn cos its needed for various other operations

any ideas gratefully rceived


Thanks

 

[birgitd]

Create an unbound text box and set the control = :

=[cmbBoxName].[Column](4)

The number in parens is the column in your combo box, BUT columns start at 0, so if you want the second value, it'll be (1).

Hope that is what you're looking for.

Birgit