A silly question: How can I create a dialogue box with 2 buttons: Yes and No

[tooold]

I am quite new with Access and programming and trying to do this: Before opening a form, I want to put a dialogue box so that if the user chooses YES, the form will be opened, If NO then it will go to the previous opened form.


I tried to look around the macro section but there is no such thing. So what would be a solution? Appreciate any help

[RuralGuy]

Can you create the Yes/No MsgBox?

[tooold]

Please be more specific: where is that Yes/No Mess Box? In Macro Section no such thing

[June7]

Bing: Access macro MsgBox yes no

Here is one http://www.access-programmers.co.uk/...d.php?t=201004

[pradeep.sands]

You can write your VBA something like this:

Dim Response As Variant
Response = MsgBox("Do you want to open this form?", vbYesNo)
If Response = vbYes Then
DoCmd.OpenForm ........
Else
'Do Nothing