ADO Recordset Update..?

Hi!

How do i cancel my ADO Recordsert from updating if the user has entered an already existing data..i was able to do so when i tried using an SQL Statement but i was wondering about the ".CancelUpdate" property of the recordset..can anyone tell me how to use this properly..pls advice..tnks in advance..!

Keiyu

After you find out whether or not the record already exists use rs.update if it doesn't and rs.cancelupdate if it does.

Or, just set the value back to it's original. For instance.

Code:

---

  '//User makes some changes, but decides to cancel now...
  txtFirstName.text = RS!FirstName

---