Find out what was updated

[gecko_1]

Hi,

I want to be able to find out what record was updated and I need to then log some details to another table. If I use the Form_BeforeUpdate event to detect that the recored will be updated,
then How do I find out what record was updated.

Thanks,
Todd

 

[WayneRyan]

Todd,

When the BeforeUpdate event fires, all of your fields will have their values.
You can access whatever Primary Keys you have for logging to an Audit
Trail.

Wayne

 

[ghudson]

Audit Trail