Recent content by dcaraher

Thanks for the reply. I'm not sure I have explained my problem clearly. The message box appears as a reult of the control button being clicked and the macro running the OpenQuery action. The query is a parameter query so the message box is asking for the parameters. If the user clicks cancel...

I have a very simple macro added to a control button which opens a parameter query. The message box that opens asks the user to input some detail, all works well if the user inputs the detail and then clicks"OK". However if they dont enter any detail and press cancel I get the action failed...