values of column property for a list box

[Goldar]

I need to get the column property values that have been selected from a two
column listbox. I try to get the column property values for the selected row
in the afterUpdate code for the list boxbut once the box has lost focus, all
the column values come back as null. What am I doing wrong?

Thanks

 

[Marshall Barton]

I need to get the column property values that have been selected from a two
column listbox. I try to get the column property values for the selected row
in the afterUpdate code for the list boxbut once the box has lost focus, all
the column values come back as null. What am I doing wrong?

Can't tell what you did wrong without seeing what you did
;-)

If it's a single select list box, there is only one value
and it is the list box's Value property.

If it's a multi select list box then you need to loop
through the list box's ItemsSelected collection and get the
value if the selected rows using the Column property.

 

[Goldar]

A further examination of my VBA code revealed my problem that was easily
corrected. Thanks for your help.