Preventing Form Close

R

ramhanuman

Registered User.

Local time

Today, 12:14

Joined

May 1, 2012

Messages

13

• May 2, 2012

• #1

If the user clicks the close button on the top right of the form window, or the big X, I made it so that it pops up a window asking the user if they really want to exit or not. If the user clicks no, how do I prevent the window from closing? Thanks

 

bob fitz

AWF VIP

Local time

Today, 20:14

Joined

May 23, 2011

Messages

4,806

• May 2, 2012

• #2

Use the form's Unload event to ask the user. If the user doesn't want to close then use this line of code to cancel the unload event:
Cancel = True

 

P

Pat Hartman

Super Moderator

Staff member

Local time

Today, 15:14

Joined

Feb 19, 2002

Messages

47,145

• May 2, 2012

• #3

There is no way to trap a click event on the Access window. For a form, you would use the UnLoad event.

If Msgbox("Do you really want to close this form?"),vbYesNo = vbNo Then
Cancel = True
End If

 

bob fitz

AWF VIP

Local time

Today, 20:14

Joined

May 23, 2011

Messages

4,806

• May 2, 2012

• #4

Pat

I think you'll find that using the code you have given, it will stop the form from closing and there by stop the app from closing as well.

I think the code you meant to post is:

Code:

If MsgBox("Do you really want to close this form?", vbYesNo[COLOR=red][B])[/B][/COLOR] = vbNo Then
Cancel = True
End If

 

P

Pat Hartman

Super Moderator

Staff member

Local time

Today, 15:14

Joined

Feb 19, 2002

Messages

47,145

• May 2, 2012

• #5

I just washed my hands and can't do a thing with them Thanks.