<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1141" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=560234002-05032003><FONT face=Arial color=#0000ff size=2>Yep,
it looks as though you've got to set cbo1.value=cbo1.defaultvalue when the new
rec is created.</FONT></SPAN></DIV>
<DIV><SPAN class=560234002-05032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=560234002-05032003><FONT face=Arial color=#0000ff
size=2>Bruce</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>
accessd-admin@databaseadvisors.com [mailto:accessd-admin@databaseadvisors.com]
<B>On Behalf Of </B>John W. Colby<BR><B>Sent:</B> Wednesday, March 05, 2003
10:45 AM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> RE:
[AccessD] default values for combos with lists<BR><BR></FONT></DIV>
<DIV><SPAN class=170384423-04032003><FONT face=Arial color=#0000ff size=2>No,
I'm saying I set the value to 0 and it was showing me
"True".</FONT></SPAN></DIV>
<DIV> </DIV>
<P><FONT size=2>John W. Colby<BR>Colby
Consulting<BR>www.ColbyConsulting.com</FONT> </P><!-- B101699BBFB441a0907FA9947EFDF6C1 -->
<P><BR>
<HR>
I've stopped <STRONG>9,258</STRONG> spam messages. You can too!<BR>Get your
free, safe spam protection at <A
href="http://www.cloudmark.com/spamnet?v1">www.cloudmark.com</A><BR><A
href="http://www.cloudmark.com/"><IMG
alt="Cloudmark SpamNet - Join the fight against spam!"
src="http://www.cloudmark.com/img/sig_join.gif" border=0 NOSEND="1"></A><BR><!-- A0C0A2D1C85242f096A170281367BF11 -->
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-admin@databaseadvisors.com
[mailto:accessd-admin@databaseadvisors.com]<B>On Behalf Of </B>Charlotte
Foust<BR><B>Sent:</B> Tuesday, March 04, 2003 6:36 PM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD] default values
for combos with lists<BR><BR></FONT></DIV><!-- Converted from text/rtf format -->
<P><FONT face="Comic Sans MS" color=#0000ff size=2>So you're saying you set
the default value to = "-1" or -1, and it's showing you 0?</FONT> </P>
<P><FONT face="Comic Sans MS" color=#0000ff size=2>Charlotte Foust</FONT>
</P>
<UL>
<P><FONT face=Arial></FONT> <FONT face=Tahoma size=1>-----Original
Message-----</FONT> <BR><B><FONT face=Tahoma size=1>From:
</FONT></B> <FONT face=Tahoma
size=1>accessd-admin@databaseadvisors.com [</FONT><A
href="mailto:accessd-admin@databaseadvisors.com"><U><FONT face=Tahoma
color=#0000ff
size=1>mailto:accessd-admin@databaseadvisors.com</FONT></U></A><FONT
face=Tahoma size=1>] </FONT><B> <FONT face=Tahoma size=1>On Behalf
Of</FONT></B> <FONT face=Tahoma size=1>John W. Colby</FONT> <BR><B><FONT
face=Tahoma size=1>Sent: </FONT></B> <FONT face=Tahoma
size=1>Tuesday, March 04, 2003 3:21 PM</FONT> <BR><B><FONT face=Tahoma
size=1>To: </FONT></B> <FONT face=Tahoma
size=1>accessd@databaseadvisors.com</FONT> <BR><B><FONT face=Tahoma
size=1>Subject: </FONT></B> <FONT
face=Tahoma size=1>RE: [AccessD] default values for combos with
lists</FONT> </P>
<P><FONT face=Arial size=2>Nope, I'm talking about the default
value.</FONT> </P>
<P><FONT face=Arial size=2>Build a combo with two columns, then make
-1;True;0;False;*;All as the list of values.</FONT> <BR><FONT face=Arial
size=2>Place 0 in the default value.</FONT> <BR><FONT face=Arial
size=2>The combo will display True when it opens (or it did with
me).</FONT> <BR><FONT face=Arial size=2>It should display false since the
0 is the false value.</FONT> </P>
<P><FONT face=Arial size=2>John W. Colby</FONT> <BR><FONT face=Arial
size=2>Colby Consulting</FONT> <BR><A
href="file://www.ColbyConsulting.com"><U><FONT face=Arial color=#0000ff
size=2>www.ColbyConsulting.com</FONT></U></A> </P><BR>
<P><FONT face=Arial size=2>I've stopped 9,258 spam messages. You can
too!</FONT> <BR><FONT face=Arial size=2>Get your free, safe spam
protection at </FONT><A
href="http://www.cloudmark.com/spamnetsig/"><U><FONT face=Arial
color=#0000ff size=2>http://www.cloudmark.com/spamnetsig/</FONT></U></A>
</P>
<P><FONT face=Arial size=2>-----Original Message-----</FONT> <BR><FONT
face=Arial size=2>From: accessd-admin@databaseadvisors.com</FONT>
<BR><FONT face=Arial size=2>[</FONT><A
href="mailto:accessd-admin@databaseadvisors.com]On"><U><FONT face=Arial
color=#0000ff
size=2>mailto:accessd-admin@databaseadvisors.com]On</FONT></U></A><FONT
face=Arial size=2> Behalf Of Charlotte Foust</FONT> <BR><FONT face=Arial
size=2>Sent: Tuesday, March 04, 2003 5:38 PM</FONT> <BR><FONT face=Arial
size=2>To: accessd@databaseadvisors.com</FONT> <BR><FONT face=Arial
size=2>Subject: RE: [AccessD] default values for combos with lists</FONT>
</P><BR>
<P><FONT face=Arial size=2>Are you talking about the ItemData, John?
That's an index that relates</FONT> <BR><FONT face=Arial size=2>to the
position.</FONT> </P>
<P><FONT face=Arial size=2>Charlotte Foust</FONT> </P>
<P><FONT face=Arial size=2>-----Original Message-----</FONT> <BR><FONT
face=Arial size=2>From: John W. Colby [</FONT><A
href="mailto:jcolby@colbyconsulting.com"><U><FONT face=Arial color=#0000ff
size=2>mailto:jcolby@colbyconsulting.com</FONT></U></A><FONT face=Arial
size=2>] </FONT><BR><FONT face=Arial size=2>Sent: Tuesday, March 04, 2003
2:27 PM</FONT> <BR><FONT face=Arial size=2>To: AccessD</FONT> <BR><FONT
face=Arial size=2>Subject: [AccessD] default values for combos with
lists</FONT> </P><BR>
<P><FONT face=Arial size=2>I discovered today that combos that display
lists use a default value</FONT> <BR><FONT face=Arial size=2>that is the
position, not the value of the 1st column. IOW, if a combo</FONT>
<BR><FONT face=Arial size=2>pulls data from a table, the default value
should be a value from the</FONT> <BR><FONT face=Arial size=2>leftmost
column in the SQL Statement feeding data to the combo. The</FONT>
<BR><FONT face=Arial size=2>value in this column that matches the default
value will be displayed.</FONT> <BR><FONT face=Arial size=2>This same
thing doesn't work for list values, in this case the number is</FONT>
<BR><FONT face=Arial size=2>the position in the list.</FONT> </P>
<P><FONT face=Arial size=2>John W. Colby</FONT> <BR><FONT face=Arial
size=2>Colby Consulting</FONT> <BR><A
href="file://www.ColbyConsulting.com"><U><FONT face=Arial color=#0000ff
size=2>www.ColbyConsulting.com</FONT></U></A> </P><BR>
<P><FONT face=Arial size=2>I've stopped 9,257 spam messages. You can
too!</FONT> <BR><FONT face=Arial size=2>Get your free, safe spam
protection at</FONT> <BR><A
href="http://www.cloudmark.com/spamnetsig/"><U><FONT face=Arial
color=#0000ff size=2>http://www.cloudmark.com/spamnetsig/</FONT></U></A>
</P>
<P><FONT face=Arial
size=2>----------------------------------------------------</FONT>
<BR><FONT face=Arial size=2>Is email taking over your day? Manage
your time with eMailBoss. Try it</FONT> <BR><FONT face=Arial
size=2>free! </FONT><A href="http://www.eMailBoss.com"><U><FONT
face=Arial color=#0000ff size=2>http://www.eMailBoss.com</FONT></U></A>
</P><BR>
<P><FONT face=Arial
size=2>_______________________________________________</FONT> <BR><FONT
face=Arial size=2>AccessD mailing list</FONT> <BR><FONT face=Arial
size=2>AccessD@databaseadvisors.com</FONT> <BR><A
href="http://databaseadvisors.com/mailman/listinfo/accessd"><U><FONT
face=Arial color=#0000ff
size=2>http://databaseadvisors.com/mailman/listinfo/accessd</FONT></U></A>
<BR><FONT face=Arial size=2>Website: </FONT><A
href="http://www.databaseadvisors.com"><U><FONT face=Arial color=#0000ff
size=2>http://www.databaseadvisors.com</FONT></U></A> <BR><FONT face=Arial
size=2>_______________________________________________</FONT> <BR><FONT
face=Arial size=2>AccessD mailing list</FONT> <BR><FONT face=Arial
size=2>AccessD@databaseadvisors.com</FONT> <BR><A
href="http://databaseadvisors.com/mailman/listinfo/accessd"><U><FONT
face=Arial color=#0000ff
size=2>http://databaseadvisors.com/mailman/listinfo/accessd</FONT></U></A>
<BR><FONT face=Arial size=2>Website: </FONT><A
href="http://www.databaseadvisors.com"><U><FONT face=Arial color=#0000ff
size=2>http://www.databaseadvisors.com</FONT></U></A> </P><BR><BR>
<P><FONT face=Arial
size=2>----------------------------------------------------</FONT>
<BR><FONT face=Arial size=2>Is email taking over your day? Manage
your time with eMailBoss. </FONT><BR><FONT face=Arial size=2>Try it
free! </FONT><A href="http://www.eMailBoss.com"><U><FONT face=Arial
color=#0000ff size=2>http://www.eMailBoss.com</FONT></U></A>
</P></UL></BLOCKQUOTE>
<DIV>
<HR>
</DIV>
<DIV>Is email taking over your day? Manage your time with eMailBoss. Try it
free! <A
href="http://www.eMailBoss.com">http://www.eMailBoss.com</A></DIV><BR>
<P><FONT size=2>---<BR>Incoming mail is certified Virus Free.<BR>Checked by
AVG anti-virus system (http://www.grisoft.com).<BR>Version: 6.0.445 / Virus
Database: 250 - Release Date:
21/01/2003<BR></FONT></P></BLOCKQUOTE></BODY></HTML>
<BR>
<P><FONT SIZE=2>---<BR>
Outgoing mail is certified Virus Free.<BR>
Checked by AVG anti-virus system (http://www.grisoft.com).<BR>
Version: 6.0.445 / Virus Database: 250 - Release Date: 21/01/2003<BR>
</FONT> </P>