Audit Fields

[DavidAC]

Hi,
i currently do a audit update on a field if the data is altered the audit is the date and time the field was last altered. What i am after is there anyway i can do a audit update if any of the fields are updated rather than just certain fields?

Thanks for any assistance
David

 

[bat17]

You are probably running your code on the Controll afterUpdate event, there is also a Form afterUpdate event that triggers whenever a record is changed. Try using this event to run your code. How you may need to modify your code depends on what you are doing with the code.

Post back if you need further help.

Peter

 

[DavidAC]

Thanks Bat that works a treat now.