I&#039;m getting this error on the starred line:<BR><BR>While NOT rsChildT.EOF<BR> objConnect.BeginTrans<BR> strQT = "UPDATE hd_rfs_detail SET owner_est_time_comp_no= " & Request.Form("owner_est_time_comp_no")<BR> strQT = strQT & "WHERE (hd_rfs_detail.cat_id = " & rsChildT("cat_id") & ") AND (hd_rfs_detail.rfs_id=" & qsrfsid & ") "<BR> objConnect.Execute strQT, ,adCmdText + adExecuteNoRecords<BR> If Err.Number &#060;&#062; 0 Then <BR> objConnect.RollbackTrans <BR> Else <BR> objConnect.CommitTrans <BR> End If <BR> **rsChildT.MoveNext<BR>Wend<BR><BR>It works when I write the code like this, but I&#039;d rather use the above:<BR>While NOT rsChildT.EOF<BR> Set rsT = Server.CreateObject("ADODB.RecordSet")<BR> strQT = "UPDATE hd_rfs_detail SET owner_est_time_comp_no= " & Request.Form("owner_est_time_comp_no")<BR> strQT = strQT & "WHERE (hd_rfs_detail.cat_id = " & rsChildT("cat_id") & ") AND (hd_rfs_detail.rfs_id=" & qsrfsid & ") "<BR> rsT.Open strQT, ObjConnect, adOpenStatic, adLockReadOnly, adCmdText<BR> rsChildT.MoveNext<BR>Wend<BR><BR><BR>...any ideas why the first code will not work? thanks!