Tracking Changes

[Kim]

I am updating one table against another table. I need to
be able to track which field in the record changed before
the query is ran. Does anyone have any ideas?

Thanks,

Kim

 

[Iris Faber]

This is what I used:

http://www.mvps.org/access/modules/mdl0021.htm
I am updating one table against another table. I need to
be able to track which field in the record changed before
the query is ran. Does anyone have any ideas?

Thanks,

Kim