Question Form not returning SQL data Field

[VBNewbee01]

Hiya
this might be a simple one for a few people,

Have the following code that creates a drop down date list,
Even though its saving into sql on submit
when the form reloads its not pulling that data back?
I think its because I need a ?if not NULL then request? statement in there somewhere
Been looking all over but no luck!
It saves into a field called LastRepDate

<tr bordercolor="#FFFFCC" bgcolor="#FDF895">
<td> Date of our last report dd/mm/yy</td>
<td><font face="Arial">


<select name="LastRepDate" id="LastRepDate">
<option value="Please Select" selected>Date</option>


<option>01</option>
<option>02</option>
<option>03</option>
<option>04</option>
<option>05</option>
<option>06</option>
<option>07</option>
<option>08</option>
<option>09</option>
<option>10</option>


</select>




On Submit - data is entered in the SQL LastRepDate field
On form reload it returns nothing
Any ideas?


thanks