Setting the default value of the form field to be a recordset entry AND the validated entry on an UPDATE form.
I have an UPDATE form that takes values from a recordset to populate the default values for each form field. However, if a user completes the form, submits, and the validation fails I'd like the default value to be the validated entries just submitted.
So, at the moment, the value is:
value="<?php echo($rsEDITNEWS->getColumnVal("njstitle")); ?>"
And in the INSERT form the value is:
value="<?php echo(ValidatedField("addnews_166","formTITLE")) ?>"
Is there a way to combine the two so that it first displays the recordset value but then, on submit and validation, the validated entry?