List Boxes

[Kelv]

Hi, I have a list box with several columns and the Rowsource is a query. I
would like to pass into variables the information contained in each column
of the selected row in the list box. Is there a way to accomplish this?

Using Access 2003 but the DB is 2000.

Thanks,

Kelv

 

[Douglas J. Steele]

Assuming the listbox is set up not to allow multiselect, in its AfterUpdate
event, put code like:

strId = Me.MyListbox.Column(0)
strName = Me.MyListbox.Column(1)
strAddress = Me.MyListbox.Column(2)