Hi there,

I have a form with a listbox that is assigned to a dataset.

In this listbox are Company-Names and I want to choose a company as the "active" company. Now I have two questions:

1. Is it possible to DISPLAY the Company-Names but to return the CustID if something is selected?

2. How do I access the return value? I've tried it the "standard-way" as with a simple listbox that is NOT connected to a DataSet, but I can't get a correct value...

Thanks in advance for your help :o)

Kind reagrds,
Michael

Hi Michael,
here i suggest the solution please try it .

set
        ListBox1.DataSource = dt
        ListBox1.DataTextField = "COMPANY_NAME"
        ListBox1.DataValueField = "CUSTID"


to access the value from listbox

val=ListBox1.SelectedItem.Value

if u have set selection mode property to multiple
then access it through for loop as

For i = 0 To ListBox1.Items.Count - 1
    If ListBox1.Items(i).Selected = True Then
        val= ListBox1.Items(i).Value
    End If
Next

hope u ll get the your solution.
Regds
Basant

s/w engg