Fails to prompt before saving record when closing form

  • Thread starter Thread starter Dan Ramer
  • Start date Start date
D

Dan Ramer

To perform some narrowly focused data manipulation, I've
created a form with a subset of fields from each record.
I open and close that form with a macro. The macro
Action that closes the special form is Close, the Object
Type is Form, the Object Name is specified appropriately,
and the Save is set for Prompt.

When I execute the macro with a Command Button on the
special form, the form closes properly but always saves
the data displayed on the form without the desired prompt
appearing. I wish to be prompted to verify this save
before the displayed record is overwritten. The problem
is not related to the SetWarnings Action. Why isn't the
macro operating properly? Or do I misunderstand the Save
property of the Close Action? If so, how may I obtain
the result I wish?

Any help would be most appreciated.
 
The Save argument for the Close action is for saving changes to the *Design*
of the form, not the data on the form. ACCESS always automatically saves the
current record on a form when the form closes.
 
Back
Top