Wait in macro until Option Chosen??

[DavidWRouse]

Within a macro I have opened a form with buttons on for the user to selct an option.

When an option have been chosen i then want to continue running the macro
an act on the results.

e.g. (Macro)

Open Form (With Options on)
[Forms]![frm_DB_DialogueBox]![DB_YN].Value = 1 StopMacro
[Forms]![frm_DB_DialogueBox]![DB_YN].Value = 2 RunCode(123)
[Forms]![frm_DB_DialogueBox]![DB_YN].Value = 3 RunCode(xyz)
Closeform (With Options on)

I want to do this within a macro, I can't work out a way of Holding the macro from continuing until an option is selected.

 

[neileg]

Why don't you end your macro when the form opens, and then run a new macro off each of the three buttons?

 

[DavidWRouse]

Thanks,
Yes I thought of that, but it's not a one off. I will be using the Options form in many macros.
It just makes the inplementation more complicated every time.

Although Thinking about it, I could encompas the different macro withitn the same macro, just under Different names.