tracking field 2

[cvaccess]

Hello,

I have a form which contains fields populated by a query when the form opens. The fields can be modified by a user (change the data in the field or fill in a field). I have been asked if it is possible to track the field changes. For example, if the user changes the date field, stamp a new field with either their username or date. Basically they would like to track whenever their is a change. Is this possible?

Please let me know if you need more detail.

Thanks.

cvaccess

 

[SiJP]

You could create two text boxes within the tables called somthing like auditUserName and auditDate. When you update the fields on the form, simply add the following code to the OnUpdate event of the fields:

auditUserName = CurrentUser 'this is a db Key work that takes the username from the system.mdw

auditDate = Date 'or Now if you want the Date and Time.

Any good?