Option box

[Paul]

I have an option box with 4 selections. I have a command button that I
crated a macro for to send an email when the command button is pushed. If
the option box has 4 names, how do I have the macro send an email to only the
person whose name is selected in the option box when the command button is
pressed?
Can someone tell me how I can create a condition so that I can send an email
to "Joe", only if Joe's name is selected in the option box?

 

[KARL DEWEY]

Use a separate action in the macro for the different e-mails and put a
condition checking the value of the option group like this --
[Forms]![YourFormName]![Frame4] = 1

 

[Paul]

Thanks!
That worked, bur I had to use the name of the option box (which is
"Department")instead of the name of option. So--
[Forms]![YourFormName]![Department] = 1.

Use a separate action in the macro for the different e-mails and put a
condition checking the value of the option group like this --
[Forms]![YourFormName]![Frame4] = 1

--
Build a little, test a little.

I have an option box with 4 selections. I have a command button that I
crated a macro for to send an email when the command button is pushed. If
the option box has 4 names, how do I have the macro send an email to only the
person whose name is selected in the option box when the command button is
pressed?
Can someone tell me how I can create a condition so that I can send an email
to "Joe", only if Joe's name is selected in the option box?