Label that amends based on combobox selection

[chrisjames25]

Hi

When i amend a combobox i want a label to adjust to reflect the current cbox input.

I have used the event change and done on change me.label = me.cbox.value and that works however the cbox has 2 columns. The unique category id and the category. So at moment if i choose the first option from cbox i get 1 appear in label as opposed to clematis for example.

Any suggestion on what code to use to select the second column from cbox value.

 

[burrina]

Refer to the Column Number. i.e. Column(2)

 

[chrisjames25]

So would that be. Me.combobox.column(2).value

 

[burrina]

If your combo record source has that a value.

 

[Galaxiom]

VBA event not required.

Use a textbox made to look like a label. No border, lock and disable.

Enter this as the ControlSource:

=combobox.Column(1)

(The Columns Collection index is Zero based.)