I need a message box with the yes to continue and run an update query or no to (well - not run it and close the message box) and a cancel option in the message box that will close the message box and stop any further macro from running.

I would prefer two message boxes - details - see attached.

What are the best arguments. I want the macro to be embedded in a control button off a main menu screen. I know this is just to show you what I need to happen - I have not (obviously had experience with these as yet).