selecting items from listbox

[kehar]

Hello, My problem is that when i try to see other datails of the person names selected in the list box, i can see the details of the firstname (first item) of the list box only and not the second onwards. So pl tell me the code to write so that I may select any names from the list box. I am using VB 6 and Access with ADODB connection.

[cguan_77]

try to post the code you have started..

[kehar]

rs. open " Select * from <table name> where name ='" & list1.text & "'",cn, adopenstatic, adlockoptimistic

and suppose the list box items are
-1. Mohan
2. Sohan
3. Rohan
When I click on Sohan or Rohan i.e. on item 2 or item 3 the programme does not respond despite having data in the table.
so how to write the code so that it should respond on selecting every
item in the list box.

[debasisdas]

try to use list1.list(list1.listindex) in pace of list1.text