MsgBox Response question

[Guest]

When a message box appears with the message I want and buttons for Yes and No
how can I get the Yes and No buttons to do specific actions?

 

[Roger Carlson]

Dim Response as Integer

Response = MsgBox("Do you want to do something?", vbYesNo)
If Response = vbYes then
'do something
Else
'do something else
End If


--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

Thanks, I was close but got stuck. Appreciate it