Hi there,
I'm relatively new to Access and have built a few basic forms each with a button that both saves the data in the form and then closes the form.
I have a time stamp on the form for when someone opens it but also want to add a time stamp to note down the time when someone saves an entry. I have been trying to do this by adding the code on the save button command but with no luck.
The code I currently have is:
Private Sub Command16_Click()
Value = Now()
DoCmd.GoToRecord , , acNewRec
DoCmd.Close
MsgBox "Thank you - Your entry has been saved"
End Sub
Through loads of testing and errors I cant work out how to record the time that the form data was saved
Can anyone help please!?