Combobox: Using non-bound column data on selection 1

[VicM]

Folks,
Is it possible to access a non-bound column's data from a selected record in a combobox?

I have a combobox containing 3 columns of data; the 1st column is the bound column containing a unique record number and is not visible; the second column is visible and contains the name associated with the unique number; and the third column is also visible and contains a boolean indication as to whether the record is active or archived.
So a record in the dropdown box might look like:

Smith, John | Yes

The hidden 1st column contains the unique record locator.

What I'm asking is: is it possible in code, say the AfterUpdate event of the combobox, to access the 'Yes' or 'No' that might be in the 3rd column?

I've tried: Me.myCombo.Column(2).Value (assuming base 0).

But I get an error saying 'Object required'.

Any suggestions?

Thanks

 

[MajP]

I think it is just
Me.myCombo.Column(2)

This returns an actual value not an object. So it does not have a value property and thus the error.

 

[VicM]

MajP
You were correct. Thanks a bunch!
Vic