Ask before saving the record in a form

A

Aarti Sx

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

thanks
 
A

Allen Browne

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Accidentally clicked 'Don't Save' on a new Powerpoint presentation! Please help! 0
A problem occurred running while microsoft access was communicating with OLE server or ActiveX Control. 0
M.S. Word 365 1
Save workbook without shapes 0
Sub projects added as read only in Master file which are saved on sharepoint 1
Split form 0
Copy previous record into form field 0
ASK Field Formatting 1

Top