oCA.UpdateCmdDataSourceType="ADO" oCA.UpdateCmdDataSource=createobject('ADODB.Command') oca.UpdateCmdDataSource.ActiveConnection = loConnDataSource oCA.UpdateCmd="UPDATE test SET testval=?catest.TESTVAL WHERE testval=?OLDVAL('TESTVAL','catest')"Thanks,