T
Tara
I would like to be able to track record changes by capturing the date and
time of change, the RecordID of the record that was changed, the name of the
field in which data was changed, the UserID of the person logged in at the
time, and the name of the table that contains the changed record. I had
originally planned on only doing this for one table, in which case I would’ve
simply used an append query in the AfterUpdate event. But I’ve now been
asked to do this for several tables, so obviously an update query isn’t the
way to go since the tables will vary. Unfortunately, I have no idea how to
approach this via code, so I really need some help. I’m already tracking the
UserID and their time In/Out of the database, if that makes any difference…
time of change, the RecordID of the record that was changed, the name of the
field in which data was changed, the UserID of the person logged in at the
time, and the name of the table that contains the changed record. I had
originally planned on only doing this for one table, in which case I would’ve
simply used an append query in the AfterUpdate event. But I’ve now been
asked to do this for several tables, so obviously an update query isn’t the
way to go since the tables will vary. Unfortunately, I have no idea how to
approach this via code, so I really need some help. I’m already tracking the
UserID and their time In/Out of the database, if that makes any difference…