Something like this? <option value="#StreetTypeID#"<cfif StreetTypeID eq FORM.StreetTypeID> SELECTED</cfif>>#StreetType#</option>
James On Wed, 2004-06-23 at 10:50, Matthew Doepel wrote: > I want a user to select a value from a drop down list on form 1, then > preselect that value in the same list on the next form, Anyone help? > > > > Drop down list query : > > > > <CFQUERY NAME="qStreetTypes" DATASOURCE="SalesAccounts"> > > SELECT StreetTypes.StreetTypeID, > StreetTypes.StreetType > > FROM StreetTypes > > ORDER BY StreetTypes.StreetType > > </CFQUERY> > > FORM 1: > > <select name="StreetTypeID" tabindex="18"> > > <option value="" selected>Select a Street > Type</option> > > <cfoutput query="qStreetTypes"> > > <option > value="#StreetTypeID#">#StreetType#</option> > > </cfoutput> > > </select> > > > > FORM 2: This is where I want the list to preselect the value from form > 1 using #FORM.StreetTypeID# > > > > <select name="StreetTypeID" tabindex="18"> > > <option value="" selected>Select a Street > Type</option> > > <cfoutput query="qStreetTypes"> > > <option > value="#StreetTypeID#">#StreetType#</option> > > </cfoutput> > > </select> > > > > Matthew Doepel > > MGD Strategic Business Solutions > > T: +61.2.9360.1555 | M: +61.417.88.55.44 > > F: +61.2.9380.6777 > > A: PO Box 1194, Darlinghurst, NSW 1300 > > E: [EMAIL PROTECTED] | W: www.mgd.com.au > > > > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] Aussie Macromedia Developers: > http://lists.daemon.com.au/ > Register now for the 3rd National Conference on Tourism Futures, being held in > Townsville, North Queensland 4-7 August - www.tq.com.au/tfconf --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
