Save prompt when form closes in Access 2003?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to prompt a user to Save/Cancel changes to a form instead of
having them save automatically when moving off a row?

I've seen solutions to put code in the On Before Update but this prompts
them when they move off of each row which can be annoying.

Thanks, Dave.
 
Is there a way to prompt a user to Save/Cancel changes to a form instead of
having them save automatically when moving off a row?

I've seen solutions to put code in the On Before Update but this prompts
them when they move off of each row which can be annoying.
Click to expand...

I'm confused.

Your first paragraph says you want to prompt them to save whenver they
move off a row.

Your second paragraph objects to prompting them to save whenever they
move off a row.

You can't have it both ways! Do you want to prompt, or not?

John W. Vinson[MVP]
 
I want to save all changes once when they close form, like editing a word or
excel spreadsheet.
 
I want to save all changes once when they close form, like editing a word or
excel spreadsheet.
Click to expand...

What's the nature of the Form? Continuous? Does it have subforms?

Note that a relational database (unlike a Word document or an Excel
spreadsheet) *is not a document*. Tables inherently DO consist of
multiple records; each record must be saved individually to disk.

If you want to (say) enter data on a mainform, and dozens of records
into a subform or multiple subforms, and then do something to save
*all* of those records in one operation, then your only good option is
to base your Form on a separate "data entry" table. In the "Save"
button you would run an Append query (or more than one) to migrate the
data from the "scratchpad" table into the "real" table.

John W. Vinson[MVP]
 
Back
Top