[AccessD] Multiple Checkboxes

Untitled DocumentOne 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/590eda5a/attachment-0001.html>