Hi

I have a recordSet that can have say up to 30 records in it.

the records are rendered to a web page for viewing

I wish to offer the client capacity to change the last field in the report which is due_date

How do i define the form and then update the changed fields to the database.

cheers

<form action="whatever">
<table>
for i = 1 to 30 ' or whatever your recordset count is.
<tr>
<td>Field 1</td>
<td>Field 2</td>
<td>Field 3</td>
 
...
 
<td>
<input type="text" name="due_date" value="<% = Whatever_Your_Due_Date_Is %>" />
<input type="hidden" name="Unique_Identifier" value="<%= Whatever_Your_Unique_Identifier_Is_Probably_An_Autonumber_From_Access %>" />
</td>
</tr>
Next
</table>
<input type="submit" value="Submit" />
</form>

Then to process:

Dim Unique_Identifier, Due_Date
Due_Date = Split (Request.Form ("Due_Date"), ", ") ' You need to split the Due Date and the Unique Identifier up since the form field will return multiple values that are comma-separated. This code will split the Due Date up into an array of the individual Due Date values.
Unique_Identifier = Split (Request.Form ("Unique_Identifier"), ", ")
for i = 0 to UBound (Due_Date)
     if IsDate (Due_Date (i)) then ' Check each Due Date to see that it's a valid date.
          database_connection.Execute ("Update Your_Table Set Due_Date = #" & Due_Date (i) & "# where Unique_IDentifier = " & Unique_Identifier (i))
     end if
Next

This won't be perfect code, and it's not optimized for speed, but it should give you the general idea.