How can I get a "Are you sure you want to quit YES/NO" prompt on an access button -

i have quit button in access 2007 called cmdquit -

how can have brings warning prompt along lines of sure want quit? yes/no

so doesn't automatically quit log form?

i have command:

private sub cmdquit_click()

if msgbox("are sure want close form?", vbyesno) = vbyes     exit sub else     cancel = true end if

end sub

so no part of prompt works yes , quit part not

thanks dan

there nothing cancel, need this:

private sub cmdquit_click()  if msgbox("are sure want close logger?", vbquestion + vbyesno, praiselogger) = vbyes      docmd.quit  end sub

If cop