<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1226" name=GENERATOR></HEAD>
<BODY style="MARGIN-TOP: 2px; FONT: 8pt Tahoma; MARGIN-LEFT: 2px">
<DIV><SPAN class=964014213-22092003><FONT face=Arial size=2>My reply (which has
not made it there yet) assumed that the user wanted to send separate e-mails to
the users. So my example could be modified to build a list of addresses as
in John's example.</FONT></SPAN></DIV>
<DIV><SPAN class=964014213-22092003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=964014213-22092003><FONT face=Arial
size=2>Bobby</FONT></SPAN></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>John
Colby<BR><B>Sent:</B> Monday, September 22, 2003 9:30 AM<BR><B>To:</B> Access
Developers discussion and problem solving<BR><B>Subject:</B> RE: [AccessD]
Multiple Checkboxes<BR><BR></FONT></DIV>
<DIV><SPAN class=809532713-22092003><FONT size=2>One way would be to use
something like:</FONT></SPAN></DIV>
<DIV><SPAN class=809532713-22092003><FONT size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=809532713-22092003><FONT size=2>If ChkA
then</FONT></SPAN></DIV>
<DIV><SPAN class=809532713-22092003> <FONT size=2>strAddr =
"Addr1@...;"</FONT></SPAN></DIV>
<DIV><SPAN class=809532713-22092003><FONT size=2>endif</FONT></SPAN></DIV>
<DIV><SPAN class=809532713-22092003><FONT size=2>If ChkB
then</FONT></SPAN></DIV>
<DIV><SPAN class=809532713-22092003> <FONT size=2>strAddr =
strAddr & "Addr2@..."</FONT></SPAN></DIV>
<DIV><SPAN class=809532713-22092003><FONT size=2>endif</FONT></SPAN></DIV>
<DIV><SPAN class=809532713-22092003><FONT size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=809532713-22092003><FONT size=2>Thus you build up the
address, adding on to the previous one.</FONT></SPAN></DIV>
<P><FONT size=2>John W. Colby<BR>www.colbyconsulting.com</FONT> </P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader 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></BLOCKQUOTE></EM></BODY></HTML>