Yes/No Messages Boxes 2

[paulbradley]

This is prob quite an easy question to all you VB buffs, but here goes.

I have a form in MSAccess and want a message box with yes and no buttons to appear, with a certain bit of code happening if yes is cliked and a different bit if no is clicked.

I guess it starts MsgBox("blah blah", than what?

Thanks.

 

[RoyVidar]

There are of course several versions. I like the one with

dim iAnswer as integer
iAnswer=MsgBox("Bla bla",vbYesNo,"More lyrics&quot
if iAnswer=vbYes then
' perform some code here
else
' the other code here
end if

There are several boks types to choose from, you'll see 'emall when you reach the first comma.

Enjoy, Roy-Vidar

 

[rene1000]

try this:

Dim msg, Style, Title, Response
msg = "Are you sure ?"
Style = vbYesNo + vbQuestion
Title = "My question"


Response = MsgBox(msg, Style, Title)

If Response = vbYes Then
'your code if answered yes
Else
'your code if answered no
End If

 

[paulbradley]

cheers!!

 

[mph1]

You might also want to view the following:

http://www.mvps.org/access/forms/frm0027.htm

In addition, the web site itself is extremely helpful, as others.

An investment in knowledge always pays the best dividends.
by Benjamin Franklin