legalhustler
Well-known Member
- Joined
- Jun 5, 2014
- Messages
- 1,191
- Office Version
- 365
- Platform
- Windows
I am reading alot of conflicting and variations online about how to stamp the date and username for a new record or if a record get's edited.
I have a multi-user database. In the database I have a data entry Form that is linked to my Table with the following invisible fields (this is set this way because I don't want these fields to show in the Form):
1) CreatedDate
2) CreatedByUser
3) ModifiedDate
4) ModifiedByUser
Note: Each record will have these fields.
Whenever a new record gets added in the data entry form I want to capture the CreatedByUser and CreatedDate. In addition, whenever a record changes or get's modified I also want to capture the ModifiedByUser and ModifiedDate. If there has been no modifications/changes to a record, then obviously these two fields (ModifiedByUser and ModifiedDate) should be empty. None of the four fields information should change if someone is just viewing the record.
Can someone put it in a clear/concise step by step way to do this.
Thanks!
I have a multi-user database. In the database I have a data entry Form that is linked to my Table with the following invisible fields (this is set this way because I don't want these fields to show in the Form):
1) CreatedDate
2) CreatedByUser
3) ModifiedDate
4) ModifiedByUser
Note: Each record will have these fields.
Whenever a new record gets added in the data entry form I want to capture the CreatedByUser and CreatedDate. In addition, whenever a record changes or get's modified I also want to capture the ModifiedByUser and ModifiedDate. If there has been no modifications/changes to a record, then obviously these two fields (ModifiedByUser and ModifiedDate) should be empty. None of the four fields information should change if someone is just viewing the record.
Can someone put it in a clear/concise step by step way to do this.
Thanks!
Last edited: