如何在将当前记录数据移除到其他表之前复制当前记录数据 [英] how can i copy current record data before remove him to other table
问题描述
嗨伙计们。
我有两张桌子他的名字
i have 2 tables his names
old_table,new_table
old_table, new_table
并将此数据放在第一个表格中( old_table )
and have this data in first table ( old_table )
,第二个表格( new_table )为空
我已从表格中获取数据( old_table )
and i have form getting his data from table ( old_table )
现在我需要当我想要删除一些记录之前的表格已删除的记录
now i need when i want delete some record by form before the deleted record
它会转移到( new_table ),之后会将其从(
it will transfer to ( new_table ) and after that it will remove him self from ( old_table )
Private Sub Form_AfterDelConfirm(Status As Integer)
' 0 = Deleted
' 2 = Undo Delete
If (Status = 0) Then
'将当前的reocrd移动到其他表之前删除他
' move current reocrd to other table before remove him
MsgBox"已删除已完成!"
MsgBox "Deleted done!"
结束如果
结束子
End If End Sub
推荐答案
为什么不将单个记录与"旧"的"是/否"字段一起显示?
Why not jut a single record with Yes/No field for 'Old?'
然后在您的查询中将条件设置为您需要查看哪些数据。
Then in your queries have criteria as to which data you need to see.
这篇关于如何在将当前记录数据移除到其他表之前复制当前记录数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!