will then load your ado recordset in Batchoptimistic mode and add this code your willmove event of ado, what you will have to do is send .updatbatch for everytime you add new or update or delete records and you can do validation only when user accept it.