update 2 fields whenever table changes

[mcgraw]

I have an Access 2007 DB with a table called tblLastUpdate which contains 4 fields:
ID, Issue_number, last_udpate, and last_update_field

I would like, whenever anything in a separate table (Issues) changes to have it the tblLastUpdate. What I'd like is to have last_update show the time/date of the last update and last_update_field to say which field was updated. (Issue_number = the foreign key to the issues table)

I have 2 problems...

1: how do I set this up so it looks for any changes in the table Issues?

2: How do I get it to call the name of the field updated to populate the last_update_field field?

Any guidance would be GREATLY appreciated!

 

[pbaldy]

It sounds like you are looking for audit trail type functionality. Search on that and you should find a number of methods. Access (through v2007 anyway) does not have table level triggers, so this is something you will have to build into the forms.