When I alter data in a table, when do the new values get save to the file?
If you're doing it in a table datasheet, I believe it's when you set focus to
another row in the table, or outside the table.
If you're doing it in a Form (as you should be doing!) the record will be
saved when you move off the last field in the record; set focus to a different
record; enter or leave a subform; or close the form.
John W. Vinson [MVP]