Get value ListBox to a Msgbox

[Guest]

hi, how can i get the value from a listbox and put the value showed in th
msgbox.
thanks

 

[Guest]

Hi Bruno,
To display a value from the List box in the message box it will be
MsgBox Me.ListFieldName.Column(2)

But if the list contain alot of values, which value do you want to display
or pass to the text box if the user didnt select any.
Unless there is only one name in the list box, in that case, can you please
post the SQL that you are using in the ListBox