<% sql = "select as_scoping,a_scoping,as_planfile,a_planfile,as_envclr,a_envclr," sql = sql + "as_rwclr,a_rwclr,as_const,a_const " sql = sql + " from TIP where tip_id=" & lnTIP_ID oPage.open sql, oConnection, adOpenKeyset, adLockBatchOptimistic, adCmdText with oPage .fields("as_Scoping").value = formatdate2(request.form("as_Scoping")) .updatebatch end with %>Today it fails on the update, BUT the new date value IS stored in the table. Not only that but the new date is stored to most but not all of the records in the table even though there is only 1 record that fits the criteria. Running a record count loop confirms that only 1 record was selected. The formatdate2 function is simply to deal with a blank date coming from the form.