I store the listbox values in the database table using the below coding:


for i= 0 to list1.listcount-1
rs.addnew
rs![fnam]=list1.list(i)
rs.update
next i

The datas are added to the table. But if i run the program second time, the same values are again added to the table. If i run second time, the values which are added to the table(at first running) must be cleared and the values should be added freshly.
How to do this using vbcoding. Please help me.