Ordinarily, an update record page will pull the existing data from the
database, display it, allow you to manually edit it, and then update the value.
What I would like to do is define the update form field in such a way that it
is automatically updated to a specific value that does not require user
For example, for the field "STATUS" Dreamweaver inserts the following code
into the initial value property for the corresponding form element on the
This just displays the current value in that field, which I can change if I
like. I want to edit this code so that it will automatically update this field
with a specified string, let's say "Checked out". If I simply add the desired
string at the end, it just appends it to the existing record rather than
updating it. I'm sure this is something simple, but I'm just not seeing it.
On a related note, how do I add today's date to a "Date Updated" field on an
update page? I know how to insert a record with today's date
<%= fmtDateTime(Now(), "yyyy-mm-dd hh:mm:ss")%>
but how do a I update a previously empty field "Date Updated" field with
today's date whenever that record is updated?