Option box

  • Thread starter Thread starter Paul
  • Start date Start date
P

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?
 
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
 
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.

KARL DEWEY said:
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.


Paul said:
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?
Click to expand...
Click to expand...
 
Back
Top