表单上的数据更改时的表单级事件 [英] Form level event for when data is changed on a form

问题描述

嗯，基本上我正在处理一个 MSAccess 应用程序和表单，管理员将在其中查看和编辑用户数据，我希望能够在更改时使用字段的旧值和新值调用事件.此函数将在审计表中添加一条记录以跟踪更改.

Well basically I am working on an MSAccess application and on the form where administrators will view and edit user data I want to be able to call an event with the old and new values of a field whenever it is changed. This function will add a record into the audit table to track changes.

我创建查询以将条目添加到审计表没有问题，但我不知道在哪里放置函数调用.我已经尝试了一些表单级别的事件，因此我不必进入 50 个字段中的每一个并编辑它们的 onBlur 事件来检查新值但没有运气.

I have no problem creating the query to add the entry to the audit table but I don't know where to place the function call. I've tried a few form level events so I don't have to go into each of the fifty fields and edit their onBlur events to check for a new value but have had no luck.

欢迎提供任何提示.

推荐答案

Microsoft 有一篇关于此的文章:如何在 Access 2000 中的表单中创建记录更改的审计跟踪.

Microsoft has an article on this: How to create an audit trail of record changes in a form in Access 2000.

这篇关于表单上的数据更改时的表单级事件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！