listbox issue

[vb6beginer]

Hi...
i have ms access table with fields like s1,s2,s3.And i have 3 values in the listbox (form 1)like 45 56 23.I want these three value should be stored in s1,s2,s3 fields respectively.
the code which i used for this is

rs(0) = List1.list(0)
rs(1) = List1.list(1)
rs(2) = List1.list(2)

but its not working.It didnt throws any error.simply this code is storing zero as a value in all fields(s1,s2,s3) of the access table.Can anyone pls help me on this..

[baja_yu]

I would call this a "database issue" rather than a listbox issue, since the problem is storing data in the DB. The solution depends on what you use to connect/communicate with the DB.

[vb6beginer]

k fine..is it possible to store all values in the listbox into the fields of table?

[baja_yu]

Yes it is but like I said the solution depends on the method you use to connect with the DB.

[vb6beginer]

I used the ADOdb connection.

[vb6beginer]

Can you pls give me the code for that to do? using Adodb connection

[baja_yu]

Searching the forums for "ADO insert record" will get you a lot of examples on how to do it. This is just one of them http://www.vbforums.com/showthread.p...ght=ado+insert

[vb6beginer]

Thank you for your help