Create a Yes/No MsgBox for Form

[helpmeee]

Hey All,

I have a switchboard (form) in a database with several buttons. One of those buttons is "Exit." Upon clicking that button, I want a MsgBox to pop up saying something along the lines of "Are you sure you wish to exit?" with the options Yes/No, and then when Yes is pressed, a "Do you want to save?" prompt.

I found this example online:

Dim LResponse As Integer
LResponse = MsgBox("Do you wish to continue?", vbYesNo, "Continue")
If LResponse = vbYes Then
{...statements...}
Else
{... statements...}
End If

But I don't know how to write statements. Currently, I have the "Exit" button linked to a "Close Form" command.. Can anyone be of any help?

 

[helpmeee]

Maybe there's something easier I can use instead of VB??