<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1226" name=GENERATOR></HEAD>
<BODY style="MARGIN-TOP: 2px; FONT: 8pt Tahoma; MARGIN-LEFT: 2px">
<DIV><FONT size=2>Thanks for all the suggestions. Bobby's suggestion is
most in line with what I'm trying to do. And, I just tried it and it
works. I had to make it more complex, though, as the fields are on a
subform, but I got it.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Thanks again to everyone.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>Terri Jarus<BR>Director, Contract Support Services<BR><A
href="mailto:jarus@amerinet-gpo.com">jarus@amerinet-gpo.com</A><BR>314-542-1902</FONT></DIV>
<DIV> </DIV>
<DIV>>>> bheid@appdevgrp.com 09/22/03 08:38AM
>>><BR></DIV><FONT face=Tahoma size=1>
<DIV><SPAN class=783522713-22092003><FONT face=Arial size=2>Hi
Terri,</FONT></SPAN></DIV>
<DIV><SPAN class=783522713-22092003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=783522713-22092003><FONT face=Arial size=2>In your situation,
what I do is name the check boxes serially. Like
chkRecip1,chkRecip2,...chkRecip1N.</FONT></SPAN></DIV>
<DIV><SPAN class=783522713-22092003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=783522713-22092003><FONT face=Arial size=2>Then I would loop
though them and process then that way.</FONT></SPAN></DIV>
<DIV><SPAN class=783522713-22092003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=783522713-22092003><FONT face=Arial size=2>Air
code:</FONT></SPAN></DIV>
<DIV><SPAN class=783522713-22092003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=783522713-22092003><FONT face=Arial size=2>'you could use a
select statement like</FONT></SPAN></DIV>
<DIV><SPAN class=783522713-22092003><FONT face=Arial size=2>for i=1 to
4</FONT></SPAN></DIV>
<DIV><SPAN class=783522713-22092003><FONT face=Arial
size=2> if me("chkRecip" & i)
then</FONT></SPAN></DIV>
<DIV><SPAN class=783522713-22092003><FONT face=Arial
size=2> </FONT></SPAN><SPAN
class=783522713-22092003><FONT face=Arial size=2>select case
i</FONT></SPAN></DIV>
<DIV><SPAN class=783522713-22092003><FONT face=Arial
size=2> case
1</FONT></SPAN></DIV>
<DIV><SPAN class=783522713-22092003><FONT face=Arial
size=2>
checked_Admin = "<A
href="mailto:MS@email.com">MS@email.com</A>"</FONT></SPAN></DIV>
<DIV><SPAN class=783522713-22092003><FONT face=Arial
size=2>
case 2</FONT></SPAN></DIV>
<DIV><SPAN
class=783522713-22092003>
<FONT size=2>checked_Admin = "</FONT><A href="mailto:LB@email.com"><FONT
size=2>LB@email.com</FONT></A><FONT size=2>"</FONT></SPAN></DIV>
<DIV><SPAN class=783522713-22092003><FONT face=Arial
size=2>
case 3</FONT></SPAN></DIV>
<DIV><SPAN class=783522713-22092003><FONT face=Arial
size=2> checked_Admin
= "#5<A href="mailto:#5@email.com">@email.com</A>"</FONT></SPAN></DIV>
<DIV><SPAN class=783522713-22092003> </SPAN><SPAN
class=783522713-22092003><FONT face=Arial
size=2> case
4</FONT></SPAN></DIV>
<DIV><SPAN class=783522713-22092003><FONT face=Arial
size=2>
checked_Admin = <A href="mailto:#4@email.com">#4<A
href="mailto:#4@email.com">@email.com</A></A></FONT></SPAN></DIV>
<DIV><SPAN class=783522713-22092003></SPAN><FONT face=Arial><FONT
size=2> </FONT><SPAN class=783522713-22092003><FONT face=Tahoma
size=1>
<FONT face=Arial size=2>end select</FONT></FONT></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=783522713-22092003>
SendMail checked_Admin 'function to send the
mail</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=783522713-22092003>
end if</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=783522713-22092003> next
i</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=783522713-22092003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=783522713-22092003>' or you could
set up an array of e-mail addresses first</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=783522713-22092003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=783522713-22092003>dim
strAddr(3)</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=783522713-22092003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=783522713-22092003> strAddr(0)="<A
href="mailto:MS@email.com">MS@email.com</A>"</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=783522713-22092003>
<DIV><FONT face=Arial size=2><SPAN
class=783522713-22092003> strAddr(1)="<A
href="mailto:MS2@email.com">MS2@email.com</A>"</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=783522713-22092003>
<DIV><FONT face=Arial size=2><SPAN
class=783522713-22092003> strAddr(2)="<A
href="mailto:MS3@email.com">MS3@email.com</A>"</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=783522713-22092003>
<DIV><FONT face=Arial size=2><SPAN
class=783522713-22092003> strAddr(3)="<A
href="mailto:MS4@email.com">MS4@email.com</A>"</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=783522713-22092003>
<DIV><SPAN class=783522713-22092003><FONT face=Tahoma
size=1></FONT></SPAN> </DIV>
<DIV><SPAN class=783522713-22092003><FONT face=Arial size=2>
for i=1 to 4</FONT></SPAN></DIV>
<DIV><SPAN class=783522713-22092003><FONT face=Arial
size=2> if me("chkRecip" &
i) then</FONT></SPAN></DIV>
<DIV><SPAN
class=783522713-22092003> SendMail
strAddr(i)</SPAN></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=783522713-22092003>
end if</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=783522713-22092003> next
i</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=1><SPAN
class=783522713-22092003></SPAN></FONT> </DIV>
<DIV><SPAN class=783522713-22092003>Hope this helps,</SPAN></DIV>
<DIV><SPAN
class=783522713-22092003>Bobby</SPAN></DIV></SPAN></FONT></DIV></SPAN></FONT></DIV></SPAN></FONT></DIV></SPAN></FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of </B>Terri
Jarus<BR><B>Sent:</B> Monday, September 22, 2003 9:15 AM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> [AccessD] Multiple
Checkboxes<BR><BR></FONT></DIV>
<DIV><FONT size=2>I have four checkboxes, which if checked, determine who
receives an email. More than one checkbox may be selected. How do
I code this so that all the applicable recipients are emailed?</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Example - four checkboxes - MS, PH, LB,
NF</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>If MS is checked - Admin = "<A
href="mailto:MS@email.com">MS@email.com</A>"</FONT></DIV>
<DIV><FONT size=2>If LB is checked - Admin = <A
href="mailto:LB@email.com">LB@email.com</A></FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>But what if MS and LB are both checked? How do I word
this?</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>I am having a brain cramp on this. Can't use Select
Case because each check box is a unique field - right?</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>If someone can point me in the right direction, I would
appreciate the help.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Thanks.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV> </DIV>
<DIV><FONT size=2>Terri Jarus<BR>Director, Contract Support Services<BR><A
href="mailto:jarus@amerinet-gpo.com">jarus@amerinet-gpo.com</A><BR>314-542-1902</FONT></DIV>
<P>---------------------------------------------------------------------------<BR>This
email and any files transmitted with it are confidential and<BR>intended
solely for the use of the individuals or entities to whom they<BR>are
addressed. If you have received this email in error please return <BR>it to
the sender, and erase any copies thereof.<BR><EM><FONT
size="><br>
<P> </font></em> <font size="><EM>Copyright 2003
AmeriNet 1nc.</EM></FONT> </P></BLOCKQUOTE></EM></FONT></BODY></HTML>