How to display combobox property in report? (1 Viewer)

[ForcedToUseIt]

Hi,

I have a report that is based on a dynamic query. The query gets it's parameters from a unbounded form. I would like to get "descriptive" text field from my combo box into the report not the stored value in the combo box.

The combobox has TypeID and TypeName columns and TypeID is the stored field. I want to see the TypeName field in my report.

I tried to put a textbox in my report and in the control source i put:
= Forms![frmName]![ControlSource].Text

but this didnt work

Any ideas on how i can do this?

Please help

 

[maxmangion]

use the column property i.e. in your case it should be .column(1), because combo boxes starts at column(0).

 

[ForcedToUseIt]

Thanx maxmangion

it works great! I had however found a workaround that used the underlying recordsource. I put this into the control source property of the textbox and it worked fine.

=IIf(IsNull(Forms!pfrmReportCustomer!ComboType);"";[Type])

But I like your solution better so I'll use it instead.

Thanx

 

[maxmangion]

you're welcome