Close Form and Prompt to Save

E

emom

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?
 
T

TonyT

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..
 
Top