[AccessD] Multiple Checkboxes

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

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Colby
Sent: Monday, September 22, 2003 9:30 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Multiple Checkboxes


One way would be to use something like:
 
If ChkA then
    strAddr = "Addr1 at ...;"
endif
If ChkB then
    strAddr = strAddr & "Addr2 at ..."
endif
 
Thus you build up the address, adding on to the previous one.

John W. Colby
www.colbyconsulting.com 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Terri Jarus
Sent: Monday, September 22, 2003 9:15 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Multiple Checkboxes


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?
 
Example - four checkboxes  - MS, PH, LB, NF
 
If MS is checked - Admin = "MS at email.com"
If LB is checked - Admin = LB at email.com
 
But what if MS and LB are both checked?  How do I word this?
 
I am having a brain cramp on this.  Can't use Select Case because each check
box is a unique field - right?
 
If someone can point me in the right direction, I would appreciate the help.
 
Thanks.
 
 
 
Terri Jarus
Director, Contract Support Services
jarus at amerinet-gpo.com
314-542-1902

---------------------------------------------------------------------------
This email and any files transmitted with it are confidential and
intended solely for the use of the individuals or entities to whom they
are addressed. If you have received this email in error please return 
it to the sender, and erase any copies thereof.


 Copyright 2003 AmeriNet 1nc. 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030922/1aaff800/attachment-0003.html>
-------------- next part --------------
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com