Report Title at runtime

[Newbie]

Hi,

I have a report on which I want to set the Title at run time

I have a form that has a combo box with 2 columns:
column 1: identifier
column 2: description

The combobox is bound to column 1 - this works fine for collecting the data
however on the title for the report I would like to place the description

Is there a way of getting the description (column 2) for the item selected
in the combobox when the combobox itself is bound to column 1?

If yes, how

Thanks

 

[Rick Brandt]

Hi,

I have a report on which I want to set the Title at run time

I have a form that has a combo box with 2 columns:
column 1: identifier
column 2: description

The combobox is bound to column 1 - this works fine for collecting the data
however on the title for the report I would like to place the description

Is there a way of getting the description (column 2) for the item selected
in the combobox when the combobox itself is bound to column 1?

Forms!NameOfForm!NameOfComboBox.Column(1)

The columns are numbered starting with zero.

 

[Newbie]

Thanks - works a treat

Forms!NameOfForm!NameOfComboBox.Column(1)

The columns are numbered starting with zero.