Hi Lorcan,  I'm working with the tag now.  John Wilker suggested it earlier.
I'm doing something wrong thou...I keep getting runtime errors..on loading
the window (Line 215) and after making the 1st selection (Line 460)  My code
is below.

<CFLOCK SCOPE="APPLICATION" TIMEOUT="30"  TYPE ="ReadOnly">
<CFQUERY DATASOURCE='#application.DSNMain#' NAME="GetCounty">
SELECT StateCode, County
FROM StateCounty
        Order by StateCode
</CFQUERY>
 </cflock>

<FORM ACTION="TestTwoSelectsRelatedGo.cfm" METHOD="POST" onSubmit="return
require_Selected();" Name="MyOtherForm">

  <CF_TwoSelectsRelated
        QUERY="GetCounty"
        NAME1="StateCode"
        NAME2="County"
        DISPLAY1="StateCode"
        DISPLAY2="County"
        VALUE1="StateCode"
        VALUE2="County"
        FORCEWIDTH1="70"
        FORCEWIDTH2="70"
        SIZE1="1"
        SIZE2="1"
        HTMLBETWEEN="<BR>"
        AUTOSELECTFIRST="Yes"
        EMPTYTEXT1="(choose a state)"
        EMPTYTEXT2="(now choose a county)"
        ONCHANGE="Submit!"
        FORMNAME="MyOtherForm">
</FORM>

 -----Original Message-----
From:   Lorcan Murphy [mailto:[EMAIL PROTECTED]]
Sent:   Tuesday, October 31, 2000 12:00 PM
To:     CF-Server
Subject:        Re: Two related Combo boxes

Hi Dan,

there is a custom tag called TwoSelectsRelated.cfm available from the
gallery which does that to perfection.

Lorcan

Dan wrote:

> Here's a hard one.  I have a form with two combo boxes (State and County).
> The problems is that the 2nd (County) combo box is based on the value of
the
> 1st (State).  I would like to keep the form together.  Is there a way to
> make the 2nd boxes values change based on the input of the 1st?
>
> --------------------------------------------------------------------------
----
> To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com



-------------------------------------------------------------------
CONFIDENTIALITY AND DISCLAIMER NOTICE

This e-mail is intended only for the addressee named above and the
contents should not be disclosed to any other person nor copies
taken. Any views or opinions presented are solely those of the
sender and do not necessarily represent those of Awarenet Ltd
(trading as Unipalm) unless otherwise specifically stated. As
internet communications are not secure we do not accept legal
responsibility for the contents of this message nor responsibility
for any change made to this message after it was sent by the
original sender. We advise you to carry out your own virus check
before opening any attachment as we cannot accept liability for any
damage sustained as a result of any software viruses.
-------------------------------------------------------------------
----------------------------------------------------------------------------
--
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com

------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with 
'unsubscribe' in the body or visit the list page at www.houseoffusion.com

Reply via email to