I do not know this is going be possible to do but want to get some ideas or better way to do. Currently I have a form that have a date call "Rec'd Date", I also have fields call Last Update (PDUPDT) and Last updated by(PDUPDUSR). I have code for the Last update and Last update by on Form BeforeUpdate:
PDUPDT = Date
PDUPDUSR = "User"
to capture what update the Rec'd Date.
What I want to do is , I want to put two Text Box on the form and show a specific user that updated this record, I don't need to be store in the table. For example: JDoe (that's the user's name), enter the Rec'd date on 2/2/15. the two text boxes on the form will show JDoe, 2/2/15, but if JSmith update the this record on 2/3/15 but not the Rec'd date because once the Rec'd Date enter, it will lock, so no one can edit the Rec'd date, but we want to know when JDoe entered the Rec'd date, that's all we looking for. these two text boxes still show JDoe, 2/2/15. Is this possible? How?