Macro to pup up MsgeBix with Continue or Quit

M

Mixer1

I have a Macro that opens a series of reports. But I want a message box that
says, in effect, "This will do such and such. Do you really want to
continue." Then a button to Continue or not.

What do I need?

Thanks for helping.
 
S

Steve Schapel

Mixer,

Access's built-in message box does not include provision for Continue or
Quit buttons.

My suggestion would be to make a little form, formatted to look like a
messge box if you like, with your message in a Label, and two Command
Buttons with your Continue and Quit options. On your initial Event, use
an OpenForm action to open this form. And then assign the existing
macro, the one that does the reports, to the Click event of the Continue
button on the custom form.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top