Printing problem

[kulanga]

Hi I am a newbie to Access and VB Programming.



I am working on a button to print a report. I included the Msgbox function so when the user clicks on the button a dialog box appears with Yes and No buttons.
The Macro is as follows:

The first action is Cancel Event with the condition " MsgBox("Do you want to print the report?",4)=7 "
Then the next action is the PrintOut with the condition "6" to print when Cancel Event action is false.
But when I click on the No button report prints as well.

What should I change in the condition of the PrintOut action?

Thank You

Kulanga.

[SoftwareMatters]

You need to put it in to an If statement. Like this:

If MsgBox("Do you want to print the report?",4)=7 then
Code here for this response
Else
Code here for other response
End if