Altering a field on a form - DB update or not?

[MikeB]

If I use VBA to set the value of a control (text box) on a form bound
to a table, is the update directly applied to the underlying record in
the table or does the update become effective only when I navigate
away from the record?

Similarly, when I use a combo box to set or alter the vale in a
control, is it immediate or deferred to another event takes place?

 

[Rick Brandt]

If I use VBA to set the value of a control (text box) on a form bound to
a table, is the update directly applied to the underlying record in the
table or does the update become effective only when I navigate away from
the record?

Similarly, when I use a combo box to set or alter the vale in a control,
is it immediate or deferred to another event takes place?

It is written to the table when the record is saved. There are numerous
events that automatically trigger a record to be saved. Navigating to a
different record is one of them. You can also...

Close the form
Requery the form (*)
Apply a filter (*)
Remove a filter (*)
Press <Shift-Enter>
VBA code - DoCmd.RunCommand acCmdSaveRecord
VBA code - Me.Dirty = False

(*) these actually trigger a save because they cause record navigation.