What a wonderful place this forum is. Thanks to this forum I've managed to capture the OS username for use in my database. A big step forward for someone of my abilities!
What I'd like to do is now to automatically capture the username and current date, when a record is updated. (the record is automatically generated with blank fields, then filled out manually by individual users). I've added a couple of new fields to the table (LastModifiedDate and LastModifiedUser) and would like these fields to be populated automatically. I'm using a form linked to a query to capture the data.
What I'm about to try is: default the fields using the functions available (NOW() and my Username function) and do that on OnRecordUpdate.... but I'm not sure if that's possible. If there is a better way, maybe you can advise me?
Thanks in advance.
JR
What I'd like to do is now to automatically capture the username and current date, when a record is updated. (the record is automatically generated with blank fields, then filled out manually by individual users). I've added a couple of new fields to the table (LastModifiedDate and LastModifiedUser) and would like these fields to be populated automatically. I'm using a form linked to a query to capture the data.
What I'm about to try is: default the fields using the functions available (NOW() and my Username function) and do that on OnRecordUpdate.... but I'm not sure if that's possible. If there is a better way, maybe you can advise me?
Thanks in advance.
JR
