I have a form where I want to add a date/time stamp each time someone goes into it and makes changes to any of the text boxes.
One record could be updated several times a day so I want the date/time to change whenever any of the users update it. I also need to have a textbox that captures the user name as well so we can track who is changing the data and on what date and time.
How can this be accomplished? I have a textbox for =currentuser and that seems to work ok. Not sure on the date/time stamp. Help is appreciated.
One record could be updated several times a day so I want the date/time to change whenever any of the users update it. I also need to have a textbox that captures the user name as well so we can track who is changing the data and on what date and time.
How can this be accomplished? I have a textbox for =currentuser and that seems to work ok. Not sure on the date/time stamp. Help is appreciated.