I have two field in a table... LastModUser (short text field) and LastModDate (short date field). When the record is either added or modified I want the LastModUser field to be populated with the user's login and I want the LastModDate field to be populated with the current date (short date).
How can I do this? I assume it will be in the beforeupdate event of the record? Or?