Close Form and Prompt to Save

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

Guest

I would like to close a form but have it prompt if you want to save the
information or cancel.

CUrrently I have this in my event procedure when they click on close for,
but it doesn't prompt, it automatically saves and closes.

clsNavigator.CloseForm

I created a macro to close form and selected the option to "prompt" but the
save thing happens.

How do I force a close form to prompt the user to save the data or cancel?
 
You can put your own message box / prompt in the forms before_update event,
and it will be triggered before every record update / save, however you may
wish to use a variable that is given a value depending on the route the user
*approaches* the update, for example if you have a 'Save' button, you may
want to ignore the prompt / msg and just save anyway.

TonyT..
 
Back
Top