Hello,

I am creating a user interface project for data to be updated/inserted into
some SQL Server tables.  My question has to do with how Access 2003 forms
handle updating records.

Basically, when using the form, I change a value of a field and go to the
next field to edit.  As soon as I take the focus off of the field I am
editing, it saves the record in the database.  I do not want the field to be
saved until the Save button is clicked.  So if someone was to close the form,
the record will revert back to what it was previously.  Can anyone please
explain how to make this behavior happen?

Cheers!
Jordan