I need to update several records at the same time.
I used
for i = 0 to 3
rs("name") = UCase(Trim(txtName(i).Text))
rs("age") = UCase(Trim(txtAge(i).Text))
rs("preference") = txtPref

rs.Update
next i

It failed to work :
"Method of update of object recordset failed"

Can anyone help me?