Msg Box with a cancel option

[chuckster]

I've have a Report that prints from a form button. I've added a MsgBox which warns the user which report it is but it only accepts "OK" and then prints. Could I put a cancel option on the message box so that the action can be cancelled and the report won't print?

Luke

 

[accesswatch]

The Access help file has an example of this under Msgbox Function (example)
Just lift the code from there
Regards
trevor from www.accesswatch.co.uk

 

[chuckster]

Thanks but now how can a use the response to end the event if the cancel button is pressed.

 

[Jack Cowley]

Dim StdResponse As Integer

StdResponse = MsgBox("Do you want to print report?", vbOKCancel + vbDefaultButton1)

If StdResponse = vbOK Then ' (Default)
Your Code to print report here
Else 'vbCancel
Exit Sub
End If