Cancel BeforeUpdate Subf on Form Close

  • Thread starter Angelsnecropolis
  • Start date
A

Angelsnecropolis

I have a Form BeforeUpdate command that displays a msgbox when certain fields
need to be updated before the record changes. However, the msgbox displays
also when closing the Form and it requires an individual to click ok, then
closes.

What code can I use to disable the whole sub on form close?

Thanks.
 

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

Making a macro only work on certain files 2
Dynamic Naming of Form Button 3
If Then for on Form Close 2
Prompt For Replace in Selection And More... 0
Add New Record for Combo Box 5
Stop Close if Dropdown not chosen 3
BeforeUpdate Problem 12
exit form button and BeforeUpdate form event 4

Top