<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1141" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=084181623-24032003><FONT face="Comic Sans MS" color=#0000ff
size=2>Don't ask me, I just answer questions. <vbg> I once had
a request for option groups that met specific business rules and allowed
multiple answers under specific circumstances.</FONT></SPAN></DIV>
<DIV><SPAN class=084181623-24032003><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=084181623-24032003><FONT face="Comic Sans MS" color=#0000ff
size=2>Charlotte Foust</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> William Hindman
[mailto:wdhindman@bellsouth.net] <BR><B>Sent:</B> Monday, March 24, 2003 2:37
PM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> Re: [AccessD]
checkboxes<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>...hhhmmm ...ok ...but why? </FONT></DIV>
<DIV><FONT face=Arial size=2>...Checkboxes can be used in an Option Group and
all the functionality is built in without a line of code :)</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>William Hindman<BR>"All it takes for evil to prevail is for good men to
do nothing." Edmund Burke<BR></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=cfoust@infostatsystems.com
href="mailto:cfoust@infostatsystems.com">Charlotte Foust</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, March 24, 2003 5:21
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] checkboxes</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=866001322-24032003><FONT face="Comic Sans MS" color=#0000ff
size=2>As William suggests, that is what option groups were created
for. However, if you want to do it with checkboxes for whatever
reason, here's how.</FONT></SPAN></DIV>
<DIV><SPAN class=866001322-24032003><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=866001322-24032003><FONT face="Comic Sans MS" color=#0000ff
size=2>Put all the checkboxes sequentially, 1 - 10, into a collection and
use the name of the checkbox as the key so you can refer to the members
either by name or by index number. Alternatively, use an array
declared as CheckBox and use the numeric portion of the name as the
index. Create a form level flag that is a boolean and set it to
True in the afterupdate event of each checkbox but only if the checkbox is
set to true. Then you can easily use the BeforeUpdate event of each
checkbox to see if the flag is already set. If it is, you can quickly
loop through the collection or the array to see which one is
set to True. The handling after that will be up to you.
You could either pop up an error message or simply change the other checkbox
to false and the current one to true. </FONT></SPAN></DIV>
<DIV><SPAN class=866001322-24032003><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=866001322-24032003></SPAN><SPAN
class=866001322-24032003><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=866001322-24032003><FONT face="Comic Sans MS" color=#0000ff
size=2>Charlotte Foust</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Pedro
Janssen [mailto:pedro@plex.nl] <BR><B>Sent:</B> Monday, March 24, 2003
2:07 PM<BR><B>To:</B> AccessD@databaseadvisors.com<BR><B>Subject:</B>
[AccessD] checkboxes<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Hello Group,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>When i have a form with 10 checkboxes (chb1
to 10) and only one may be True.</FONT></DIV>
<DIV><FONT face=Arial size=2>Is there a way to get an error
message when you select two checkboxes as True.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>TIA</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Pedro Janssen</FONT></DIV></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>