Track change in any field in the form

[Daniel]

Good afternoon,

Which event will permit me to track the user if he/she edit a record? I
want to place the CurrentUser's name in the ModBy field of my tbl_main
whenever they edit any field in a form (and this for each individual record).

Thank you,

Daniel P

 

[Paul Overway]

Use the BeforeUpdate event for the form.