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
vb code Code:
  1. rs(0) = List1.list(0)

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

  3. 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..