我是VBA / MS access的新手，所以在调试过程中很费劲。我已经为我们数据库中的子表单组成了一个审计跟踪。它正在记录数据，但是添加新记录后，我的审核跟踪未记录任何编辑。因此，我添加了一个新条目。它将数据记录在表中。我编辑该条目，它没有记录数据。我的子表单基于查询而不是表，因此不确定是否是它的原因吗？

从子窗体调用审核跟踪：

'''

const Discord = require('discord.js')
const client = new Discord.Client()
const MIN_INTERVAL = 1 * 60 * 1000;
// 1 minutes,60 seconds in a minute,1000 milliseconds in a second

client.on('ready',function(){
    console.log("Ready,connected as " + client.user.tag);
setInterval(function(){
    var generalChannel = client.channels.get("12345678910"); // Replace with known channel ID
    generalChannel.send("Hello,world!") ;
},MIN_INTERVAL);
});

bot_secret_token = "qwertyuiop"

client.login(bot_secret_token)

'''

并记录数据：

''' 期权比较数据库 显式选项

Private Sub Form_BeforeUpdate(Cancel As Integer)
   If MsgBox("Changes have been made to this record." _
    & vbCrLf & vbCrLf & "Do you want to save these changes?" _,vbYesno,"Changes Made...") = vbYes Then
        If Me.NewRecord Then
              Call AuditChangesSub("tblTestData.tblCert","New")
        Else
             Call AuditChangesSub("tblTestData.tblCert","Edit")
        End If
  Else
       Me.Undo
  End If

End Sub

'''