Bruce Bruen
bbruen at bigpond.com
Tue Mar 4 20:45:01 CST 2003
Yep, it looks as though you've got to set cbo1.value=cbo1.defaultvalue when the new rec is created. Bruce -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com] On Behalf Of John W. Colby Sent: Wednesday, March 05, 2003 10:45 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] default values for combos with lists No, I'm saying I set the value to 0 and it was showing me "True". John W. Colby Colby Consulting www.ColbyConsulting.com _____ I've stopped 9,258 spam messages. You can too! Get your free, safe spam protection at HYPERLINK "http://www.cloudmark.com/spamnet?v1"www.cloudmark.com HYPERLINK "http://www.cloudmark.com/"Cloudmark SpamNet - Join the fight against spam! -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com]On Behalf Of Charlotte Foust Sent: Tuesday, March 04, 2003 6:36 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] default values for combos with lists So you're saying you set the default value to = "-1" or -1, and it's showing you 0? Charlotte Foust -----Original Message----- From: accessd-admin at databaseadvisors.com [HYPERLINK "mailto:accessd-admin at databaseadvisors.com"mailto:accessd-admin at database advisors.com] On Behalf Of John W. Colby Sent: Tuesday, March 04, 2003 3:21 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] default values for combos with lists Nope, I'm talking about the default value. Build a combo with two columns, then make -1;True;0;False;*;All as the list of values. Place 0 in the default value. The combo will display True when it opens (or it did with me). It should display false since the 0 is the false value. John W. Colby Colby Consulting HYPERLINK "file://www.ColbyConsulting.com"www.ColbyConsulting.com I've stopped 9,258 spam messages. You can too! Get your free, safe spam protection at HYPERLINK "http://www.cloudmark.com/spamnetsig/"http://www.cloudmark.com/spamnetsi g/ -----Original Message----- From: accessd-admin at databaseadvisors.com [HYPERLINK "mailto:accessd-admin at databaseadvisors.com]On"mailto:accessd-admin at datab aseadvisors.com]On Behalf Of Charlotte Foust Sent: Tuesday, March 04, 2003 5:38 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] default values for combos with lists Are you talking about the ItemData, John? That's an index that relates to the position. Charlotte Foust -----Original Message----- From: John W. Colby [HYPERLINK "mailto:jcolby at colbyconsulting.com"mailto:jcolby at colbyconsulting.com] Sent: Tuesday, March 04, 2003 2:27 PM To: AccessD Subject: [AccessD] default values for combos with lists I discovered today that combos that display lists use a default value that is the position, not the value of the 1st column. IOW, if a combo pulls data from a table, the default value should be a value from the leftmost column in the SQL Statement feeding data to the combo. The value in this column that matches the default value will be displayed. This same thing doesn't work for list values, in this case the number is the position in the list. John W. Colby Colby Consulting HYPERLINK "file://www.ColbyConsulting.com"www.ColbyConsulting.com I've stopped 9,257 spam messages. You can too! Get your free, safe spam protection at HYPERLINK "http://www.cloudmark.com/spamnetsig/"http://www.cloudmark.com/spamnetsi g/ ---------------------------------------------------- Is email taking over your day? Manage your time with eMailBoss. Try it free! HYPERLINK "http://www.eMailBoss.com"http://www.eMailBoss.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com HYPERLINK "http://databaseadvisors.com/mailman/listinfo/accessd"http://databaseadv isors.com/mailman/listinfo/accessd Website: HYPERLINK "http://www.databaseadvisors.com"http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com HYPERLINK "http://databaseadvisors.com/mailman/listinfo/accessd"http://databaseadv isors.com/mailman/listinfo/accessd Website: HYPERLINK "http://www.databaseadvisors.com"http://www.databaseadvisors.com ---------------------------------------------------- Is email taking over your day? Manage your time with eMailBoss. Try it free! HYPERLINK "http://www.eMailBoss.com"http://www.eMailBoss.com _____ Is email taking over your day? Manage your time with eMailBoss. Try it free! HYPERLINK "http://www.eMailBoss.com"http://www.eMailBoss.com --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.445 / Virus Database: 250 - Release Date: 21/01/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.445 / Virus Database: 250 - Release Date: 21/01/2003 -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030304/b75a73b3/attachment-0001.html>