Audit table setValue macro

G

grahamsyuk

Joined
Jul 18, 2007
Messages
3
Reaction score
0
Hi there, i am new to MS access so hopefully someone can help me. I wish to create an audit table that records any changes to a main database table. I also have a form linked to the main database table. I had hoped that i could run a macro after any form element has been updated using the 'AfterUpdate' trigger. In the macro i then planned to use the setValue function to add a row in the audit table but this appears not to work. Is there another way that this can be done?
 
Back
Top