Does anyone have the vb code for adding a confirm button after the user has changed data on the form? I have a data saved macro that runs after an update but I want to insert a confirm message prior to activating the "data saved" alert. This would be for an existing record.

__________________
Mike

Can I assume you're using unbound forms?
If that's the case, then just write the code before your update statement.

If you're using bound forms, then it's a bit messier, and you'll probably have to end up putting code in all your bound objects' After Update events.

So what's it to be? Bound or unbound?

I am a loud man with a very large hat. This means I am in charge

The form is bound to the table. The records are inserted and updated through the form. I wanted to add a failsafe Confirm button if changes were made and not correct. I have the macro running prior to the macro that verifies the save but there is no option to cancel. That is what I am missing.