<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1141" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=073164802-05032003><FONT face=Arial color=#0000ff size=2>Going
into edit mode is not the same as closing the form. Edit mode keeps the
last state of the form. This includes record selected, filters etc.
Closing the form gets rid of this "last state" (usually).</FONT></SPAN></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,263</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 dir=ltr style="MARGIN-RIGHT: 0px">
<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>Bruce
Bruen<BR><B>Sent:</B> Tuesday, March 04, 2003 9:37 PM<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=700083402-05032003><FONT face=Arial color=#0000ff size=2>How
very interesting. BUT.... when I first opened the form it did show
False, then I selected True, closed (well went into edit mode) and reopened it
and it showed True. The same thing happened when All was
selected.</FONT></SPAN></DIV>
<DIV><SPAN class=700083402-05032003><FONT face=Arial color=#0000ff size=2>So I
guess it has something to do with the itemselected
thingodoodyattribute???</FONT></SPAN></DIV>
<DIV><SPAN class=700083402-05032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=700083402-05032003><FONT face=Arial color=#0000ff size=2>hth
</FONT></SPAN></DIV>
<DIV><SPAN class=700083402-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><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<P><FONT size=2>John W. Colby<SPAN class=700083402-05032003><FONT face=Arial
color=#0000ff> </FONT></SPAN><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><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></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></BODY></HTML>