I have a class written for the database functions: Insert, update, delete, retrieve.


Scenario:
Load form:

NAME

ADDRESS

City

State

Zip

[Close][Apply][Delete][Add][Cancel]

This forms allow users to make multiple changes without committing each change. User can cancel all changes if he so desires. I am using BeginTrans, CommitTrans and RollbackTrans.

Problem is with the updates. Is there a recordset property that set it to an "updated" state? I need to update and requery everytime a user scrolls through the records and only if a change has been made. Is there an easy way to do this?

Thanks.