e-mail prompts in checkboxes

  • Thread starter Thread starter Lauren B.
  • Start date Start date
L

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
 
Lauren B. said:
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.
Click to expand...


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...
 
Back
Top