[AccessD] Multiple Checkboxes

How about storing the e-mail address in the check box's Tag property and then check each check box like this:

Dim Admin As String
Dim tmp As String
	If MS.Checked = True Then
		tmp = MS.Tag & ";"
	End If
	If LB.Checked = True Then
		tmp = tmp & LB.Tag & ";"
	End If
	Admin = tmp

And so on.  I'm using the semi-colon to delimit the e-mail list so change to whatever your mail system recognizes.

HTH, 

Jim DeMarco 
Director of Product Development 
HealthSource/Hudson Health Plan 

-----Original Message-----
From: Terri Jarus [mailto:jarus at amerinet-gpo.com]
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. 


***********************************************************************************
"This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged.  If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited.  If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message.  Thank You".
***********************************************************************************