INSERT and UPDATE Initialization Execution

[Jim]

When you are using a form in Access, and you change a
field value or fill out the form for new record, how is
that change propagated in the database table. For
example, say that I have a text box field on a form where
a user can change the existing value or add a completely
new record. They user then opens the form, changes the
value in a field, then moves onto the next field. When
is the UPDATE executed (when the text field loses focus)
and by what (ODBC, OLE DB, Jet etc.)

Thanks Jim,

 

[James Goodman]

The change is commited when the user moves record, or closes the form by
default. I believe the method is Jet...