p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access (http://p2p.wrox.com/forumdisplay.php?f=18)
-   -   Confirm Button after update (http://p2p.wrox.com/showthread.php?t=11705)

fixitman April 11th, 2004 10:41 PM

Confirm Button after update
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.

Steven April 12th, 2004 03:21 PM

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

fixitman April 12th, 2004 03:28 PM

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.

All times are GMT -4. The time now is 09:34 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.