|
To save old data in another table use Save old data record in another table
action.
Available in following
events:
 Note: Change the values listed in
red to match your specific needs.
'********** Save old data record in another table ************
dim rsFields
set rsFields = dal.Table(strTableName).Query(where,"")
if not rsFields.eof then
dal.Table("AnotherTable").Field1=rsFields("rsFields1")
dal.Table("AnotherTable").Field2=rsFields("rsFields2")
dal.Table("AnotherTable").Add()
end if
rsFields.close: set rsFielgs=nothing
|
|
