Yes No msgbox

[imintrouble]

Hello! I have a message box in the unload portion of my ONE form. When the user clicks yes, it will run some code and then close. When they click no or cancel, i don't care which, it simply returns the user to the form without closing the database down.

like if a person tries to close out of access, because the form is to always be up hence the need for a message box asking if they really want to close it, the message box pops up. "Click YES if you want to log-out. Click No/Cancel if you are not yet ready to log-out."



yes runs code and closes as normal, no/cancel returns the user to the form without closing access. it sounds simple, but thats just me.

[June7]

What is your issue?

[imintrouble]

I don't know how to make this kind of message box that has just a yes and a no and which also, when no is clicked, keeps access open with the database still open as well. If yes is selected i wish for it to simply close as normal.

basically this is an, Are you sure you want to close? yes to close, no to not close.

[June7]

MsgBox has two forms: a function and a simple popup. The function is structured with parens and must be part of an expression. See http://msdn.microsoft.com/en-us/libr...(v=vs.60).aspx

Example:
intResponse = MsgBox("Do you want to quit?", vbQuestion + vbYesNo)

This is also possible:
If MsgBox("Do you want to quit?", vbQuestion + vbYesNo) = vbYes Then
'do something
End If

Simple popup:
MsgBox "Procedure completed successfully"