Ask before saving the record in a form

  • Thread starter Thread starter Aarti Sx
  • Start date Start date
A

Aarti Sx

How can I control when a record is saved or not? please
suggest using macros in ms-access.

thanks
 
Use the Before Update event of your form (not that of a control).

The form's Before Update runs just before the record is saved.
You can MsgBox anything that needs confirmation, and CancelEvent if it is
not satisfactory.
 
Back
Top