retreiving listbox value???

[AccessDevJunior]

hya,
i have a list box and a text box within a vb6 form.
i have put code on the afterupdate() event of the list box:
me.text1 = me.listbox1
in ms access the text box value will equal the selected row of the list box, but this is not the case in vb6.

does anyone know how i can use the listbox as a value?

 

[HarleyQuinn]

Hi,

You could try:

Text1.Text = ListBox1.SelectedItem

Hope this helps

Harleyquinn

 

[AccessDevJunior]

hya, thanx for the advice.
the code still does not seem to be working could it have anything to do with the listbox/textbox properties?

 

[HarleyQuinn]

Hi,

What is not working with the code??

Could you put a break on that line of code and look at what the Listbox1.SelectedItem value is returning at runtime?

Harleyquinn

 

[vladk]

Private Sub List1_Click()
Text1.Text = List1.List(List1.ListIndex)
End Sub

 

[AccessDevJunior]

hya
harleyquinn, im getting an error:
method or data member not found!
vladk code seems to have done the trick though, thanx for the help

 

[HarleyQuinn]

Hi,

Sorry about that, I had forgotten I was in the VB6 forum and I posted a VB.NET solution by mistake.

Apologies

Harleyquinn

 

[jajinder]

Let this noobie try to help you.... P)

I presume that you made a Connection with a database.

Private Sub List1_Click()
Set rs = New ADODB.Recordset
    rs.Open "SELECT * FROM Page1 WHERE Name = '" & List1.Text & "'", cn, adOpenDynamic
If Not rs.EOF And Not rs.BOF Then Text1.Text = rs.Fields("NAMEOFFIELD").Value

etc.... et......

End Sub

'Page1 is the name the AccesPage
'Name is the name of the field/row within the AccesPage

---------------------------------------
This will be the day when all of God’s children will be able to sing with a new meaning, “My country, ‘tis of thee, sweet land of liberty, of thee I sing. Land where my fathers died, land of the pilgrim’s pride, from every mountainside, let freedom ring. - Marten Luther King

 

[Dashley]

Accesevjr


You can use the listbox "click event".
When the client clicks on a name in the listox just capture the name in a var then process it. Theres also a dblclick event if you want the client to be extra sure thats the name they want.


Dan