Using the onchange event

[kjspear]

Hello Everyone:

I have a question about using the onchange command, if this is the appropiate command to use. My manager would like to have access keep track of any changes that the users do to the records. Right now, I'm using the update query where access copies a record to another table along with the users ID and date, whenever a record is deleted from the main table. This way my manager can keep track as to who is deleting records. I would like to know can this be done when a user changes a record. For example, if in the field 'Name1': Bob, the user changes it to 'Name1': Robert, this is also copied to another table that shows the changes that were done to that record.

Please let me know if you require more information.

Thank You,
KJ

 

[M8KWR]

you could also use the afterupdate procedure as well.

You would need to capture the data as they go into the field, and compare this to the data as they leave the fields, and then update a table, sounds quite easy to do..

Good luck,