listbox select item

[meme'1992]

Hi,
I have a listbox , fill with a select. I want to select a value in the listbox and pass in another select.

Private Sub lista_persone_Click()
Dim tmpR As DAO.Recordset
Set tmpR = CurrentDb.OpenRecordset("SELECT Exam FROM Exam WHERE NAME_PERSON = '" & Me.lista_persone.Selected & "' ")
Me.txt_exam= tmpR.Fields(0)
End sub

But Me.lista_persone.Selected is wrong and gives me an error.
How can I select the value?
Thanks

 

[meme'1992]

Relsove! I use Me.lista_persone.Value and works!!!

 

[moke123]

you dont need the .value.

Me.lista_persone will give you the value of the first column, if there is more than one.

Me.lista_persone.column(1) will give you the value of the second column. the columns are zero based.

 

[meme'1992]

Yes, the columns are 3. How can assign to each colomn the value? I make a select and a recordset. Can I use fields of recordeset?

 

[moke123]

How can assign to each colomn the value?

The column property is for Reading the value, not setting it.