Help on Message Box

  • Thread starter Thread starter Bart
  • Start date Start date
B

Bart

I have an existing form that will ask for a message "IS THE STATUS CORRECT?"
when exiting the form. If the user select YES button, then the current form
will be closed, and when NO button is selected, the current form will remain
open.

Please help me to do this. Thanks in advance!
 
In the forms On Unload event put this code

If MsgBox("Is the Status Correct ?", vbYesNo, "Confirm") = vbNo Then
Cancel = True
End If
 
In the forms On Unload event put this code

If MsgBox("Is the Status Correct ?", vbYesNo, "Confirm") = vbNo Then
Cancel = True
End If
 

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

Access MS access forms list box problems 1
Excel VBA - Problem with Closing Print Preview 0
Access Sub form opens before the main form in MS Access 0
enable a combo box in one form based on input in another form 6
Excel Providing user message when RED X clicked & properly closing application. 2
Closing form without saving changes 4
Access Determine what query to run based on a checkbox 0
Exiting Access 4

Back
Top