e-mail prompts in checkboxes

[Lauren B.]

I have the event procedure for several check boxes set so that when it is
clicked by a user, an e-mail prompt to the appropriate address opens.
However, if the box is unchecked, the same e-mail prompt opens, and an error
message is received if it is closed without sending a message.

Is there a way to have an e-mail prompt open when a box is checked but, when
it is unchecked not have the prompt open.

Thank you in advance for your assistance.

*Lauren

 

[Rick Brandt]

I have the event procedure for several check boxes set so that when it is
clicked by a user, an e-mail prompt to the appropriate address opens.
However, if the box is unchecked, the same e-mail prompt opens, and an error
message is received if it is closed without sending a message.

Is there a way to have an e-mail prompt open when a box is checked but, when
it is unchecked not have the prompt open.

Thank you in advance for your assistance.

How are you producing the prompt? Macro or VBA code? With VBA you would simply
test the value of the Checkbox.

If Me.CheckBoxName = True Then...