Can columns of RecordSource be used in event procedure?

[Richard]

Suppose an unbound combo box CHOICE has a row source
SELECT id,shortinfo,longinfo from Choices
and has
column count 3
column widths 0;1;2
and has
after update [event procedure]

in
function CHOICE_AfterUpdate()
can I or how would I access the longinfo portion of the CHOICE ?

MsgBox CHOICE only shows the id of the choice.
I would like to work with the shortinfo and longinfo.

[Allen Browne]

For the current record, you can use the combo's Column property, e.g.:
=[CHOICE].Column(2)

Notes
1. Column() is zero-based: the first columns is zero, the 2nd is one, and so
on.
2. This doesn't work for all the rows of a continuous form/datasheet.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Richard" <ri************@devenezia.comwrote in message
news:11**********************@a75g2000cwd.googlegr oups.com...

Suppose an unbound combo box CHOICE has a row source
SELECT id,shortinfo,longinfo from Choices
and has
column count 3
column widths 0;1;2
and has
after update [event procedure]

in
function CHOICE_AfterUpdate()
can I or how would I access the longinfo portion of the CHOICE ?

MsgBox CHOICE only shows the id of the choice.
I would like to work with the shortinfo and longinfo.