I have a form set up with 3 select lists where a user can select the date. and from there I insert it into one field in an Access database using this query.

<cfquery name="CheckDate" datasource="Rumors_Forms">
INSERT INTO BusTable (Name, Req_Date, Req_Time, Address, Email, PhoneNumber, Reason)
 Values('#form.Name#', '#form.Month#/#form.Day#/#form.Year#' ,'#form.Req_Time#','#form.Address#','#form.Email#','#form.PhoneNumber#','#form.Reason#')
</cfquery>

it inserts into the DB just fine, what I would like to do, is have all the information output to a form. The thing I am having problems with is getting the date to populate in 3 select lists. here is my code that I have for the select lists.

<td>Date:</td>
			<td><cfparam name="form.month" default="">	   <select name="Month">
		  <cfloop  index="month" from =1 to =12 >
             <cfif month EQ form.month>
                <cfoutput><option value="#month#" selected>#month#</option></cfoutput>
             <cfelse>
                <cfoutput><option value ="#month#">#month#</option></cfoutput> 
             </cfif>
          </cfloop>
       </select>
   
   <cfparam name="form.day" default="">

      <select name="Day">
	     <cfloop  index="day" from =1 to =31 >
            <cfif day EQ form.day>
               <cfoutput><option value="#day#" selected>#day#</option></cfoutput>
            <cfelse>
               <cfoutput><option value ="#day#">#day#</option></cfoutput> 
           </cfif>
        </cfloop>
      </select>

   <cfparam name="form.year" default="">

      <select name="Year">
	     <cfloop  index="year" from =2006 to =2010 >
            <cfif year EQ form.year>
               <cfoutput><option value="#year#" selected>#year#</option></cfoutput>
            <cfelse>
               <cfoutput><option value ="#year#">#year#</option></cfoutput> 
           </cfif>
        </cfloop>
      </select></td>

Any help would be great.
Thanks

This question has already been answered. Start a new discussion instead.