"Joe" wrote
I have a form which displays data
in 3 related tables. I want to give
the user a prompt to save changes
when any field has been modfied on
the form.
If this is a "bound form", that is, has a RecordSource of a Query that joins
the three related tables, then the data will be saved if the record is
changed -- saving will take place automatically when you move off the record
to another, or move to a subform control on the form, or close the form. You
can also save explicitly via VBA code using the statement Me.Dirty = False,
or DoCmd.RunCommand acSaveRecord, by the menu, or by a PF key action.
Explicit action to save is rarely needed except in special cases.
If you are using an unbound form, that is, using your own VBA code to read
the data, put it in controls for display, etc., then you will have to
determine the conditions under which the record needs to be saved, which
specific record needs to be saved, and perform the save yourself in your VBA
code. I do not recommend using unbound forms for handling data, as a general
rule.
Larry Linson
Microsoft Access MVP