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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setvalue from a Table Row 2
setting the argument in SETVALUE Action of macro 6
'SetValue macro action' problem 4
Using SetValue in sub-form macro 5
SetValue for a Toggle Button on a subform 1
setvalue action changes record focus 5
Setvalue function not appearing in macro definition 1
Where did the SetValue action go? 5

Top