Hi all,

Does anyone know how to get the columns of a listbox selected item and store it to a string? There is no multi-selection so it should be easier. I tried
s$ = Me.list1.selected but it keeps giving me an error

Thanks alot

Hi
Are your options for your list box stored in a seperate table?

You can refer to each column in a listbox or combobox through an index starting with 0. So for instance (immediate pane)

? Me!MyList.Column(0) ' first column
? Me!MyList.Column(4) ' fift column

The bound column, if bound, can be retrieved for instance using

Me!MyList

or

Me!MyList.Value

^^^ Thanks roy that worked. :D

Take care