On Deactivate or Unload

[DoctorJDM]

Hi

Have an order form whose contents need to be saved if a user hasn't completed all details and/or switches to another window.

Have tried using On Deactivate to put up a warning asking if the record needs to be saved. Only trouble is it's too enthusiastic and triggers if any other command button is clicked (eg print record) or design view is entered.

Ideally the warning should arise only if the user closes the form prematurely or opens another form.

What's best to use?

Thanks

 

[Remou]

It is probably a good thing to save before printing, or you may end up printing old data. Perhaps you can use different events, On Close for example?

 

[DoctorJDM]

Thanks Remou, need to try, back later.