6 replies
There are several ways to do this. One way is to create a field that you want to store the time in (ex: xTimeStamp). In the table, specify the data type of the field as Date/Time and set the formatting for what you want (short time, long time, etc.). Next, add the field to the form, set the Enable attribute to No and the Locked attribute to Yes (this will prevent the field form being edited by the user). Create a command button and put the following code in the OnClick event:
Dim xDate as Date
xDate = Now
Me.xTimeStamp = xDate
DoCmd.GoToRecord , , acNewRec
Lastly, remove the Navigation Buttons from the form.
by layland
by kkenkel513
by layland
This discussion is closed to new replies.
Trending Software posts
Sort by Trending